MySQL 中 TEXT 資料型態的長度限制


1
2
3
4
TINYTEXT: 256 bytes
TEXT: 65,535 bytes => ~64kb
MEDIUMTEXT: 16,777,215 bytes => ~16MB
BIGTEXT: 4,294,967,295 bytes => ~4GB

參考: http://www.electrictoolbox.com/maximum-length-mysql-text-field-types/