手动转码UTF8转 UTF8MB4问题！
2023-04-14 21:05 来自 𝕷𝖎𝖑𝖏𝖆𝖈𝖐 发布@ Discuz! X3.5专区
前面转了几十张都正常，就这张pre_ucenter_badwords(utf8)转不动
工具：PHPMYadmin
转码语句：
USE qianwanmeiren;ALTER TABLE pre_ucenter_badwords CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
错误提示：
错误静态分析：
分析时发现1个错误。
Missing comma before start of a new alter operation. (near "CHARACTER SET" at position 44)
SQL 查询：
ALTER TABLE pre_ucenter_badwords CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
MySQL 返回： http://localhost/phpMyAdmin4.8.5/themes/dot.gif
#1071 - Specified key was too lon
工具：PHPMYadmin
转码语句：
USE qianwanmeiren;ALTER TABLE pre_ucenter_badwords CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
错误提示：
错误静态分析：
分析时发现1个错误。
Missing comma before start of a new alter operation. (near "CHARACTER SET" at position 44)
SQL 查询：
ALTER TABLE pre_ucenter_badwords CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
MySQL 返回： http://localhost/phpMyAdmin4.8.5/themes/dot.gif
#1071 - Specified key was too lon
