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
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.
Could that be a TINYTEXT field, limited to a maximum of 256 characters?
Reference:
[https://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html][1]