The differences between BLOB and TEXT
来源:互联网 发布:2017东欧旅游市场数据 编辑:程序博客网 时间:2024/05/12 10:39
A BLOB
is a binary large object that can hold a variable amount of data. The four BLOB
types are TINYBLOB
, BLOB
, MEDIUMBLOB
, and LONGBLOB
. These differ only in the maximum length of the values they can hold. The four TEXT
types are TINYTEXT
, TEXT
, MEDIUMTEXT
, and LONGTEXT
. These correspond to the four BLOB
types and have the same maximum lengths and storage requirements.
BLOB doesn't have a character set, but TEXT has.
Keeping in mind the caveats above about max packet size and RAM, here are the sizes of each of the text types:
TINYBLOB, TINYTEXT:
2^8 or 256 bytes
BLOB, TEXT:
2^16 or 65536 bytes (64 kiB)
MEDIUMBLOB, MEDIUMTEXT:
2^24 or 16777216 bytes (16 MiB)
LONGBLOB, LONGTEXT:
2^32 or 4294967296 bytes (4 GiB)
- The differences between BLOB and TEXT
- The differences between Direct3D9 And Direct3D10
- The Differences Between Java, C And C++
- The differences between 'alt' and 'title' !
- Differences Between the Import and Load Utility
- the differences between wait and waitpid
- the differences between Crystal and Oscillator
- The differences between implements and extends
- The Differences Between MBR and GPT
- The differences between processes and threads?
- The differences between String, StringBuffer and StringBuilder
- The Differences Between Data, Information and Knowledge
- The differences between scanf() and gets()
- The differences between Define and Inline
- The differences between define and typedef
- the differences between groovy and java
- Differences between the C Locale and the C++ Locales
- The Differences of Dietary Cultures Between China and the West
- 人生三件事不能等----
- Segmentation Fault
- xp home edition 版本如何安装iis
- IE的主页被强制改成了http://www.3448.com的解决方法
- C++ 杂项
- The differences between BLOB and TEXT
- 宇宙:一些有趣的数字
- 迅雷(XUNLEI)的工作原理揭密(续)---为何遭封杀及如何应对?
- 怎么样学习开发游戏呢?
- 天才数学家阿贝尔和伽罗瓦
- 支持IE、Firefox的popupMenu
- 何意百炼钢,化为绕指柔——-记 Laplace
- 歌名:江湖笑 演唱:周华健
- 追忆信息论之父-香农博士