{"id":207229,"date":"2020-11-25T19:07:43","date_gmt":"2020-11-25T11:07:43","guid":{"rendered":"http:\/\/4563.org\/?p=207229"},"modified":"2020-11-25T19:07:43","modified_gmt":"2020-11-25T11:07:43","slug":"%e4%b8%8d%e5%bb%ba%e8%ae%ae-mysql-%e4%bd%bf%e7%94%a8-text-%e7%b1%bb%e5%9e%8b%ef%bc%8c%e5%af%b9%e4%ba%8e-text-%e5%86%85%e5%ae%b9%e6%af%94%e8%be%83%e7%9f%ad%e5%b0%8f%e4%b9%9f%e4%b8%8d","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=207229","title":{"rendered":"\u201c\u4e0d\u5efa\u8bae MySQL \u4f7f\u7528 Text \u7c7b\u578b\u201d\uff0c\u5bf9\u4e8e Text \u5185\u5bb9\u6bd4\u8f83\u77ed\u5c0f\u4e5f\u4e0d\u80fd\u7528\u5417\uff1f"},"content":{"rendered":"
\n
\n
\n

\u201c\u4e0d\u5efa\u8bae MySQL \u4f7f\u7528 Text \u7c7b\u578b\u201d\uff0c\u5bf9\u4e8e Text \u5185\u5bb9\u6bd4\u8f83\u77ed\u5c0f\u4e5f\u4e0d\u80fd\u7528\u5417\uff1f <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : miniyao <\/span> <\/i> 3<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\u4e00\u822c\u77e5\u9053 longtext \u548c\u5927\u7684 blob \u653e\u5728 MySQL \u91cc\u4f1a\u5f71\u54cd\u6027\u80fd\u3002<\/p>\n

\u5982\u679c\u53ea\u662f\u653e\u4e00\u4e9b\u77ed\u5c0f tinytext \u3001text \u4e5f\u4f1a\u5f71\u54cd\u6027\u80fd\u5417\uff1f<\/p>\n

\u6bd4\u5982\u6709\u4e2a\u5b57\u6bb5\u5927\u7ea6\u5728 300~500 \u4e2a\u5b57\u7b26\uff0c\u90a3\u8981\u4e48\u7528 varchar(512)\uff0c\u6216\u8005\u76f4\u63a5\u7528 text\uff0c\u8fd9\u4e24\u79cd\u65b9\u5f0f\uff0c\u6027\u80fd\u5dee\u522b\u4f1a\u5f88\u5927\u5417\uff1f <\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (27<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : warcraft1236 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u522b\u7684\u4e0d\u77e5\u9053\uff0c\u5c31\u77e5\u9053 text \u662f\u6ca1\u6cd5\u6574\u4f53\u52a0\u7d22\u5f15\u7684\uff0c\u4e5f\u662f\u524d\u591a\u5c11\u4e2a\u5b57\u7b26\u52a0\u5230\u7d22\u5f15\u91cc\u8fb9 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : xuanbg <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u65e2\u7136 varchar \u591f\u7528\uff0c\u5c31\u4e0d\u8981\u7528 text \u4e86\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RedisMasterNode <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    InnoDB \u91cc\u9762\u51b3\u5b9a TEXT \u548c Blob \u7c7b\u578b\u662f\u5426\u8981\u5916\u8054\uff08\u4e5f\u5c31\u662f\u653e\u5230\u5916\u90e8\u7a7a\u95f4\uff09\u4f9d\u636e\u662f\u4e00\u4e2a\u9875\u4e2d\u662f\u5426\u80fd\u591f\u5b58\u653e\u4e0b 2 \u884c\u6570\u636e\uff0c\u5982\u679c\u4e0d\u53ef\u4ee5\uff0cText \u548c Blob \u5c31\u4f1a\u5916\u8054\uff0c\u5426\u5219\u5c31\u4f1a\u5b58\u5728\u884c\u5185\uff0c\u8fd9\u65f6\u548c varchar \u7b49\u6ca1\u6709\u4ec0\u4e48\u5dee\u5f02\u3002\u6309\u7167\u4f60\u7684\u63cf\u8ff0\u5982\u679c\u53ea\u6709 300-500 \u4e2a\u5b57\u7b26\uff0c\u8fd9\u65f6\u5019 TEXT \u4f1a\u8868\u73b0\u5f97\u548c varchar \uff08 500 \uff09\u7c7b\u4f3c\u3002<\/p>\n

    \u5927\u90e8\u5206\u4f7f\u7528 TEXT \u548c BLOB \u7684\u65f6\u5019\u90fd\u662f\u8981\u5b58\u50a8\u597d\u51e0 KB \u3001MB \u7684\u5185\u5bb9\uff0c\u53ef\u4ee5\u8003\u8651\u6e05\u695a\u81ea\u5df1\u8981\u5b58\u4ec0\u4e48\u4e1c\u897f\u518d\u5b9a<\/p>\n

    \u5bf9\u4e8e\u7d22\u5f15\uff0c\u6211\u731c\u53ef\u4ee5\u901a\u8fc7\u7d22\u5f15\u5b57\u6bb5\u5185\u5bb9\u7684\u5f00\u5934 xxx \u5b57\u7b26\u5904\u7406\uff0c\u53ef\u4ee5\u81ea\u884c\u5c1d\u8bd5\u4e00\u4e0b <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sagaxu <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u90a3 mysql \u5e72\u561b\u8981\u6709 text \u7c7b\u578b\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    `VARCHAR` \u5927\u4e8e\u67d0\u4e9b\u6570\u503c\u7684\u65f6\u5019\uff0c\u5176\u4f1a\u81ea\u52a8\u8f6c\u6362\u4e3a `text`\uff0c\u5927\u6982\u89c4\u5219\u5982\u4e0b\uff1a<\/p>\n

    – \u5927\u4e8e varchar(255) \u53d8\u4e3a `TINYTEXT`
    – \u5927\u4e8e varchar(500) \u53d8\u4e3a `TEXT`
    – \u5927\u4e8e varchar(20000) \u53d8\u4e3a `MEDIUMTEXT`<\/p>\n

    \u5728\u67d0\u4e2a\u5730\u65b9\u770b\u5230\u7684 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4e2a\u4eba\u611f\u89c9\u7528 varchar \u4e0d\u7528 text \u4e3b\u8981\u539f\u56e0\u662f varchar \u53ef\u4ee5\u7075\u6d3b\u8bbe\u7f6e\u957f\u5ea6\uff0c\u8bed\u4e49\u6e05\u6670\u7684\u540c\u65f6\u907f\u514d\u957f\u5ea6\u8d85\u957f\u3002varchar \u5e95\u5c42\u5c31\u662f text \u7684\u8bdd\uff0c\u6027\u80fd\u5e94\u8be5\u662f\u6ca1\u6709\u533a\u522b\u7684\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Hanggi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6362 Postgresql \u597d\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RedisMasterNode <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wnanbei \u5e95\u5c42\u4e0d\u662f Text<\/p>\n

    https:\/\/stackoverflow.com\/questions\/25300821\/difference-between-varchar-and-text-in-mysql <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : keepeye <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4e2a\u4eba\u4e60\u60ef\u8d85\u8fc7 255 \u7684\u957f\u5ea6\uff0c\u90fd\u7528 text <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wd <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    varchar \u53ef\u4ee5\u9650\u5236\u6700\u5927\u5b57\u7b26\u6570\uff0c\u8d85\u4e86\u662f\u6ca1\u6cd5\u5b58\u7684\u3002\u4f46\u662f text \u6ca1\u6709\u9650\u5236\uff0c\u5982\u679c\u51fa\u4e86\u5f02\u5e38\u662f\u6709\u53ef\u80fd\u5b58\u8d85\u51fa\u4f60\u60f3\u8c61\u7684\u6570\u636e\u7684\u3002\u6240\u4ee5\u5bf9\u4e8e\u5df2\u77e5\u662f\u957f\u5ea6\u6709\u9650\u7684\u6570\u636e\uff0c\u5efa\u8bae\u7528 varchar \u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dorothyREN <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6362 PG \u5427\uff0c\u65e0\u8111 text <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : qwerthhusn <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5bf9\u4e8e Text \u5185\u5bb9\u6bd4\u8f83\u77ed\u5c0f\u65f6\u4e0d\u5efa\u8bae\u4f7f\u7528\uff0c\u5927\u7684\u65f6\u5019\u5c31\u53ef\u4ee5\u6b63\u5e38\u7528\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : love <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f88\u591a\u4eba\u7684\u6027\u80fd\u74f6\u9888\u90fd\u662f\u60f3\u8c61\u51fa\u6765\u7684\uff0cTEXT \u7684\u6027\u80fd\u4f1a\u4ea7\u751f\u6027\u80fd\u74f6\u9888\uff1f\u4f60\u8bd5\u8fc7\u4e86\u561b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : titititi <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6b63\u597d\u4eca\u5929\u770b\u7684\u4e00\u7bc7\u5173\u4e8e Text \u7c7b\u578b\u7684\u6587\u7ae0<\/p>\n

    https:\/\/juejin.cn\/post\/6898479206087262222 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : raaaaaar <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5c31\u6211\u62ff\u90a3 web \u63a5\u53e3\u7684\u4f7f\u7528\uff0c\u6839\u672c\u4e0d\u53ef\u80fd\u6709\u5565\u74f6\u9888 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : guisheng <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6211\u4e0d\u63a5\u53d7\u5b83\u7684\u5efa\u8bae\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : loading <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u4e0d\u8981\u63d0\u524d\u4f18\u5316\uff0c\u5148\u628a app \u5199\u51fa\u6765\u518d\u8bf4\u3002 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : loading <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6709\u4e00\u672c\u4e66\uff0c\u6211\u6ca1\u770b\uff0c\u4e66\u540d\u5c31\u591f\u4e86\u3002
    \u300a\u8981\u641e\u5b9a\uff0c\u4e0d\u8981\u5b8c\u7f8e\u300b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Flymachine <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wd \u4f60\u4e00\u8bf4\u8fd9\uff0c\u6211\u60f3\u5230\u4e86\u65e5\u672c\u6597\u9c7c\u4e4b\u524d\u5bf9\u76f4\u64ad\u5f39\u5e55\u957f\u5ea6\u6ca1\u6709\u9650\u5236\u3002\u8ba9 NGA \u8001\u54e5\u641e\u51fa\u4e86 16G \u6838\u5f39\u5f39\u5e55\u3002\u80fd\u8ba9\u5185\u5b58 16G \u4ee5\u4e0b\u7684\u89c2\u770b\u5f39\u5e55\u7684\u7535\u8111\u5168\u90e8\u6491\u70b8\u3002\u636e\u8bf4\u8fd8\u80fd\u641e\u51fa 32G \u7684\u5f39\u5e55\u3002\u4e0d\u8fc7\u73b0\u5728 BUG \u4fee\u590d\u4e86\u3002\u5e94\u8be5\u5c31\u662f\u8fd9\u5757\u7684\u95ee\u9898 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @RedisMasterNode \u770b\u6211 5L \u7684\u56de\u590d <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RedisMasterNode <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wnanbei varchar \u548c text \u4e0d\u4f1a\u8f6c\u4e92 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : no1xsyzy <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @loading https:\/\/tutorial.ponylang.io\/
    The Pony Philosophy: Get Stuff Done <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @RedisMasterNode \u55ef\uff1f<\/p>\n

    For a column that has a data type of VARCHAR or one of the TEXT types, changes the data type as necessary to ensure that the new column is long enough to store as many characters as the original column. For example, a TEXT column has two length bytes, which store the byte-length of values in the column, up to a maximum of 65,535. For a TEXT column, each character requires a single byte, so the column can store up to 65,535 characters. If the column is converted to , each character might require up to three bytes, for a maximum possible length of 3 \u00d7 65,535 = 196,605 bytes. That length does not fit in a TEXT column’s length bytes, so MySQL converts the data type to MEDIUMTEXT, which is the smallest string type for which the length bytes can record a value of 196,605. Similarly, a VARCHAR column might be converted to MEDIUMTEXT. CONVERT TO CHARACTER SETlatin1utf8<\/p>\n

    https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/alter-table.html <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @RedisMasterNode \u8fd8\u6709<\/p>\n

    Specifying the attribute for a character data type causes the column to be created as the corresponding binary data type: CHAR becomes BINARY, VARCHAR becomes VARBINARY, and TEXT becomes BLOB. For the ENUM and SET data types, this does not occur; they are created as declared. Suppose that you specify a table using this definition: CHARACTER SET binary<\/p>\n

    https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/silent-column-changes.html <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RedisMasterNode <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wnanbei \u8bf7\u6ce8\u610f\u8fd9\u90e8\u5206\u89c4\u5219\u89e6\u53d1\u7684\u6761\u4ef6\uff0cvarchar \u7c7b\u578b\u4e0d\u4f1a\u5728\u4f60\u8fdb\u884c\u6570\u636e\u6539\u52a8\u65f6\u8f6c\u6362\u4e3a text\uff0c\u8fd9\u90e8\u5206\u64cd\u4f5c\u65f6\u5728 create\/alter table \u65f6\u89e6\u53d1\u7684\uff0c\u5e76\u4e14\u6761\u4ef6\u8f83\u4e3a\u4e25\u82db<\/p>\n

    In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement.
    – If strict SQL mode is not enabled, a VARCHAR column with a length specification greater than **65535** is converted to TEXT.<\/p>\n

    \u800c\u5728\u6570\u636e\u7c7b\u578b\u786e\u8ba4\u4e0b\u6765\u540e\uff0c\u5982\u679c\u6ca1\u6709 alter table\uff0c\u53ea\u5bf9\u6570\u636e\u8fdb\u884c\u6539\u52a8\uff0c\u6570\u636e\u7c7b\u578b\u662f\u4e0d\u4f1a\u53d8\u5316\u7684 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : wnanbei <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @RedisMasterNode \u65e2\u7136\u4e0d\u7ba1\u5728 create \u8bed\u53e5\u8fd8\u662f alter \u8bed\u53e5\u7684\u65f6\u5019\u90fd\u4f1a\u9759\u9ed8\u66f4\u6539\u7c7b\u578b\uff0c\u90a3\u4e48\u8fd9\u4e0d\u5c31\u662f\u7b49\u4ef7\u5417 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : RedisMasterNode <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @wnanbei \u55ef\uff0c\u90a3\u8fd9\u4e2a\u662f\u6211\u7406\u89e3\u9519\u4e86\uff0c\u6211\u4ee5\u4e3a\u4f60\u8bf4\u7684\u662f varchar \u5728\u4f7f\u7528\u8fc7\u7a0b\u4e2d\u4f1a\u6839\u636e\u957f\u5ea6\u8f6c text\uff0c\u8fd9\u4e2a\u662f\u6211\u6574\u9519\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    \u201c\u4e0d\u5efa\u8bae MySQL \u4f7f\u7528 Tex…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/207229"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=207229"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/207229\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=207229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=207229"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=207229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}