mysql上,在text字段上插入字节数为88399的字符串,出现如下提示:
Data truncation: Data too long for column '***' at row 1
经查,text支持上限是65536bytes(64KB)
下述取自: Maximum length for MySQL TEXT field types
- TINYTEXT: 256 bytes
- TEXT: 65,535 bytes => ~64kb
- MEDIUMTEXT: 16,777,215 bytes => ~16MB
- BIGTEXT: 4,294,967,295 bytes => ~4GB
alter table tblneighbor modify localmap mediumtext;