mysql - 无法将表字符集编码从 latin1_swedish_ci 更改为 utf8mb4_bin

Question

尝试通过此查询更改表

 ALTER TABLE `outlooks` CHANGE `description` `description` TEXT    CHARSET=utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL;

但出现错误

 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL' at line 1

Answer 1

这不是正确的语法。该错误也非常清楚地表明了问题所在。

根据the manual它应该看起来像:

ALTER TABLE `outlooks`
CHANGE `description`
`description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL;

但是，这不会将数据表的内容从 ISO-8859-1 转换为 UTF8。你可能是looking for :

ALTER TABLE `outlooks` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;