在mysql表中,有一个包含以下内容的文本字段。
- 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
但是当我导出最后几个字被截断的字段时。请告诉我为什么phpMyAdmin导出会截断这些字符
- 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
最佳答案
如果使用的是char、varchar或tinytext,则限制为255个字符。您可能需要不同的db列类型。
编辑:
我还发现了这个:Why is the PHPMyAdmin import truncating text fields in some of my UPDATEs?
尝试将导入编码从utf-8更改为ansi。
关于php - PHPMYADMIN导出会截断MYSQL数据库的文本字段,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/28797701/