mysql in 截断_MySQL文本列被截断

I have a MySQL database in which I am storing a bunch of textual info into a Text field in the database. The columns is

Name: info

Type: text

Collation: utf8_general_ci

I had a user insert ~64kb of information into the field and it freaks out. It will truncate the last 3 characters off. Which in this case happen to be the ending to a tab so it screws up everything after it on the page. If I manually go into the database and remove a couple letters and add the back then next time I go to edit it those last 3 will be removed again.

phpmyadmin is stating that the field is to long and may not be editable. So I tried to edit it on my cms page and I still recieved the same result.

Are there any known problems with this much data in a single database text column in mysql? It does not seems like there should be.

解决方案

I think the max size of a MySQL TEXT field is smaller than 2^16 bytes. Using UTF-8 encoding, this can mean even less characters. You could use MEDIUMTEXT for 2^24 or LONGTEXT for 2^32 bytes instead, see the MySQL-Docs for details.

Ah, and make sure to check your max_allowed_packet size.