MySQL TEXT数据的长度
来源:互联网 发布:下载打印机软件 编辑:程序博客网 时间:2024/05/11 06:51
MySQL TEXT数据的长度
MySQL supports 4 TEXT field types (TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT) and this post looks at the maximum length of each of these field types.
MyISAM tables in MySQL have a maximum size of a row of 65,535 bytes, so all the data in a row must fit within that limit. However, the TEXT types are stored outside the table itself and only contribute 9 to 12 bytes towards that limit. (For more information about this refer to the MySQL Manual - Data Storage Requirements chapter).
TEXT data types are also able to store much more data than VARCHAR and CHAR text types so TEXT types are what you need to use when storing web page or similar content in a database.
The maximum amount of data that can be stored in each data type is as follows:
TINYTEXT 256 bytes
TEXT 65,535 bytes ~64kb
MEDIUMTEXT 16,777,215 bytes ~16MB
LONGTEXT 4,294,967,295 bytes ~4GB
In most circumstances the TEXT type is probably sufficient, but if you are coding a content management system it’s probably best to use the MEDIUMTEXT type for longer pages to ensure there are no issues with data size limits.
- MySQL TEXT数据的长度
- mysql的text字段长度
- mysql数据库 text类型的长度限制
- MySQL text类型的最大长度
- MySQL TEXT数据类型的最大长度
- MySQL TEXT数据类型的最大长度
- mysql text 长度
- mysql text 长度
- 【转载】mysql text 长度
- mysql的text字段长度?mysql数据库中text字段长度不够的问题
- mysql的text字段长度?mysql数据库中text字段长度不够的问题
- mysql中类型长度以及text和varchar的区别
- mysql 数据长度
- mysql text,blog长度 mediumblog longblog
- mysql中text最大长度是多少?
- mysql数据库中text类型长度
- 嵌入式 mysql数据库中text最大长度
- MS SQL Server 计算nText、Text、Image的字段的数据长度
- SVN 自动部署到开发环境
- strong weak assign copy等修饰词什么时候用
- UI控件--CheckBox
- 农民讲习所——通用程序设计
- 获取TTF里面的字体名称
- MySQL TEXT数据的长度
- MYsql 索引
- 【追求进步】变态跳台阶
- 网口编号
- 背景图片剪裁之background-size
- 名字修饰约定extern "C"与extern "C++"浅析
- mac下android-ndk-r10e-darwin-x86_64.bin解压
- CGI与Servlet的比较
- PPOJ 2492 A Bug's Life(分层并查集)