PHPMYADMIN导出截断MYSQL数据库的文本字段

Question

In MYSQL table, there is a Text field which contains the below contents.

- Pedal car with high carbon steel frame in fade resistant powder coat finish- Synthetic rubberized wheels for a smooth, low- noise ride- Safety features include oversized anti- slip pedals, dual rear wheel hand brake and fully enclosed chain guard- 3 position easy adjust high- back racing seat and sporty steering wheel- Coasting shifter</p> - 125102342ETCF4Y

But when i export the field that last few words are truncating. Please let me know why PHPMYADMIN export truncating these characters

- Pedal car with high carbon steel frame in fade resistant powder coat finish- Synthetic rubberized wheels for a smooth, low- noise ride- Safety features include oversized anti- slip pedals, dual rear wheel hand brake and fully enclosed chain guard- 3 pos

Answer 1

If you're using CHAR, VARCHAR, or TINYTEXT you have a 255 character limit. You're going to want a different db column type potentially.

EDIT:

I also found this: Why is the PHPMyAdmin import truncating text fields in some of my UPDATEs?

Try changing your import encoding from UTF-8 to ANSI.