<legend id='NQzan'><style id='NQzan'><dir id='NQzan'><q id='NQzan'></q></dir></style></legend>

          <bdo id='NQzan'></bdo><ul id='NQzan'></ul>
        <i id='NQzan'><tr id='NQzan'><dt id='NQzan'><q id='NQzan'><span id='NQzan'><b id='NQzan'><form id='NQzan'><ins id='NQzan'></ins><ul id='NQzan'></ul><sub id='NQzan'></sub></form><legend id='NQzan'></legend><bdo id='NQzan'><pre id='NQzan'><center id='NQzan'></center></pre></bdo></b><th id='NQzan'></th></span></q></dt></tr></i><div id='NQzan'><tfoot id='NQzan'></tfoot><dl id='NQzan'><fieldset id='NQzan'></fieldset></dl></div>

        <tfoot id='NQzan'></tfoot>
      1. <small id='NQzan'></small><noframes id='NQzan'>

      2. MySQL 中的 BLOB 和 TEXT 数据类型有什么区别?

        What are the differences between the BLOB and TEXT datatypes in MySQL?(MySQL 中的 BLOB 和 TEXT 数据类型有什么区别?)
        • <bdo id='ZpkJm'></bdo><ul id='ZpkJm'></ul>

            1. <small id='ZpkJm'></small><noframes id='ZpkJm'>

              <i id='ZpkJm'><tr id='ZpkJm'><dt id='ZpkJm'><q id='ZpkJm'><span id='ZpkJm'><b id='ZpkJm'><form id='ZpkJm'><ins id='ZpkJm'></ins><ul id='ZpkJm'></ul><sub id='ZpkJm'></sub></form><legend id='ZpkJm'></legend><bdo id='ZpkJm'><pre id='ZpkJm'><center id='ZpkJm'></center></pre></bdo></b><th id='ZpkJm'></th></span></q></dt></tr></i><div id='ZpkJm'><tfoot id='ZpkJm'></tfoot><dl id='ZpkJm'><fieldset id='ZpkJm'></fieldset></dl></div>
            2. <tfoot id='ZpkJm'></tfoot>

                <legend id='ZpkJm'><style id='ZpkJm'><dir id='ZpkJm'><q id='ZpkJm'></q></dir></style></legend>

                  <tbody id='ZpkJm'></tbody>
                  本文介绍了MySQL 中的 BLOB 和 TEXT 数据类型有什么区别?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  什么是blob,什么是text?有什么区别?

                  What is blob and what is text? What are the differences?

                  什么时候需要使用blob,什么时候需要text 作为数据类型?

                  When do I need to use blob and when do I need text as data type?

                  因为对于blobtext,有mediumblob == mediumtext, smallblob == <代码>小文本.它们甚至具有相同的含义吗?

                  Because for blob and text, there are mediumblob == mediumtext, smallblob == small text. Do they even have the same meaning?

                  再看这个MEDIUMBLOBMEDIUMTEXT L + 3个字节,其中L <224.

                  And look at this MEDIUMBLOB, MEDIUMTEXT L + 3 bytes, where L < 224.

                  什么是L?

                  推荐答案

                  TEXT 和 CHAR 将转换为/从它们与时间关联的字符集.BLOB 和 BINARY 只是存储字节.

                  TEXT and CHAR will convert to/from the character set they have associated with time. BLOB and BINARY simply store bytes.

                  BLOB 用于存储二进制数据,而 Text 用于存储大字符串.

                  BLOB is used for storing binary data while Text is used to store large string.

                  BLOB 值被视为二进制字符串(字节字符串).它们没有字符集,排序和比较都是基于列值中字节的数值.

                  BLOB values are treated as binary strings (byte strings). They have no character set, and sorting and comparison are based on the numeric values of the bytes in column values.

                  TEXT 值被视为非二进制字符串(字符串).它们有一个字符集,并根据字符集的排序规则对值进行排序和比较.

                  TEXT values are treated as nonbinary strings (character strings). They have a character set, and values are sorted and compared based on the collation of the character set.

                  http://dev.mysql.com/doc/refman/5.0/en/blob.html

                  这篇关于MySQL 中的 BLOB 和 TEXT 数据类型有什么区别?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How to delete duplicate records in mysql database?(如何删除mysql数据库中的重复记录?)
                  Python Pandas write to sql with NaN values(Python Pandas 使用 NaN 值写入 sql)
                  MySQL Insert amp; Joins(MySQL 插入 amp;加入)
                  MySQL concat() to create column names to be used in a query?(MySQL concat() 创建要在查询中使用的列名?)
                  NodeJS responded MySQL timezone is different when I fetch directly from MySQL(当我直接从 MySQL 获取时,NodeJS 响应 MySQL 时区不同)
                  WHERE datetime older than some time (eg. 15 minutes)(WHERE 日期时间早于某个时间(例如 15 分钟))

                          <small id='RchJx'></small><noframes id='RchJx'>

                          <legend id='RchJx'><style id='RchJx'><dir id='RchJx'><q id='RchJx'></q></dir></style></legend>
                        • <tfoot id='RchJx'></tfoot>
                            <bdo id='RchJx'></bdo><ul id='RchJx'></ul>
                              <tbody id='RchJx'></tbody>

                            <i id='RchJx'><tr id='RchJx'><dt id='RchJx'><q id='RchJx'><span id='RchJx'><b id='RchJx'><form id='RchJx'><ins id='RchJx'></ins><ul id='RchJx'></ul><sub id='RchJx'></sub></form><legend id='RchJx'></legend><bdo id='RchJx'><pre id='RchJx'><center id='RchJx'></center></pre></bdo></b><th id='RchJx'></th></span></q></dt></tr></i><div id='RchJx'><tfoot id='RchJx'></tfoot><dl id='RchJx'><fieldset id='RchJx'></fieldset></dl></div>