Tinytext |
bytes |
|
TEXT |
65,535 bytes |
~64kb |
Mediumtext |
16,777,215 bytes |
~16mb |
Longtext |
4,294,967,295 bytes |
~4gb |
Http://blog.sina.com.cn/s/blog_71f8aa010100vusp.html
MySQL multiple text field report 8126 error (resolution process)
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. Some columns to TEXT or BLOBs
If you increase the contents of the Schedule_remark field, the above error will be reported. Row size too large. Indicates that there is too much content in the line, that is, there is too much content stored on line 220567. The back of you has the some columns to TEXT or blobs is confusing because the content of the Schedule_remark field does not increase to 65k (the TEXT type is 65k maximum), the above error is reported. It appears that only shortened text content.
The field size of the text type is also limited
A new text field also appears with the above problem.