mysql的text欄位長度
型別是可變長度的字串,最多65535個字元;
可以把欄位型別改成MEDIUMTEXT(最多存放16777215個字元)或者LONGTEXT(最多存放4294967295個字元).
MySQL supports 4 TEXT field types (TINYTEXT, TEXT, MEDIUMTEXT and LONGTEXT) andthis 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 thedata in a row must fit within that limit. However, the TEXT types are storedoutside the table itself and only contribute 9 to 12 bytes towards that limit.(For more information about
this refer to the MySQL Manual - Data StorageRequirements chapter). TEXT data types are also able to store much more datathan VARCHAR and CHAR text types so TEXT types are what you need to use whenstoring web page or similar content in a database. The maximum
amount of datathat 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 circumstancesthe TEXT type is probably sufficient, but if you are coding a contentmanagement system it's probably best to use the MEDIUMTEXT type for longerpages to ensure there are no issues with data size limits.
相關文章
- MySQL的欄位數量以及長度限制MySql
- MySQL 如何儲存長度很長的資料欄位MySql
- MySQL中需要注意的欄位長度問題MySql
- mysql的varchar欄位最大長度真的是65535嗎?MySql
- oracle 修改表欄位的長度Oracle
- MySQL中欄位型別與合理的選擇欄位型別;int(11)最大長度是多少?varchar最大長度是多少?MySql型別
- MySQL中TEXT與BLOB欄位型別的區別MySql型別
- Oracle 修改欄位型別和長度Oracle型別
- SAP主資料的欄位長度(ECC6.0)
- MySQL 5.6使用pt-online-schema-change線上修改大表欄位長度MySql
- 欄位長度前後端是否都需要做限制?後端
- 請問mysql裡面的text欄位怎麼進行模糊查詢MySql
- 資料庫text型別的長度?資料庫型別
- mysql的text/blob和行溢位MySql
- DDL操作導致欄位長度變更修復方案
- [BUG反饋]username欄位的長度設定有點小問題。
- 【MySql】mysql 欄位個數的限制MySql
- MySQL VARCHAR型別欄位到底可以定義多長MySql型別
- 修改欄位長度應用會影響到生產效能
- MySQL欄位的取值範圍MySql
- MySQL 按照指定的欄位排序MySql排序
- MySQL 欄位約束MySql
- mysql中文欄位排序MySql排序
- Oracle系統檢視中address欄位長度與db位數的關係Oracle
- MySQL欄位新增註釋,但不改變欄位的型別MySql型別
- sqlloader匯入資料_資料檔案的欄位超出最大長度SQL
- SQL SERVER 查詢表的欄位名、資料型別和最大長度SQLServer資料型別
- MySQL-刪除欄位MySql
- MySQL 大欄位問題MySql
- mysql表最多欄位數MySql
- 美創科技運維日記|Oracle欄位長度引起的思考length()和lengthb()運維Oracle
- 批量修改欄位長度,考慮主鍵外來鍵索引的情況【轉】索引
- 要慎用mysql的enum欄位的原因MySql
- OGG複製同步,提示欄位長度不夠ORA-01704
- 地理位置經緯度在Mysql中用什麼欄位型別MySql型別
- PHP+MySql獲取自動增長欄位的新新增記錄ID值PHPMySql
- mysql表操作(alter)/mysql欄位型別MySql型別
- MySQL-去掉不為null的欄位MySqlNull