尝试通过此查询更改表
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
最佳答案
那不是正确的语法。该错误也很清楚出在哪里。
根据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;