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

Question

在MYSQL表中，有一个Text字段，包含以下内容。

- 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

Answer 1

如果您使用的是 CHAR、VARCHAR 或 TINYTEXT，则有 255 个字符的限制。您可能需要不同的数据库列类型。

编辑:

我还发现了这个:Why is the PHPMyAdmin import truncating text fields in some of my UPDATEs?

尝试将您的导入编码从 UTF-8 更改为 ANSI。