The solution is to alter all TEXT and related fields to their binary counterparts, then alter the character set and finally change the binary data type fields back to TEXT.

解决办法就是将所有的文本和相关的栏，更改为对应的二进制，然后更改字符集，然后再将二进制数据类型重新更改为文本。

youdao

For example, a field whose data type is text can store data consisting of either text or number characters, but a number field can store only numerical data.

例如，数据类型为“文本”的字段可以存储由文本或数字字符组成的数据，而“数字”字段只能存储数值数据。

youdao

Existing database management system cannot efficiently support biological sequence data type and its operations, people have to use text data type in database management system or text file directly.

当前的数据库管理系统不能有效地支持生物序列数据类型和操作，人们不得不用文本数据类型或直接使用文本文件存储生物序列数据。

youdao