1267, “Illegal mix of collations (latin1_swedish_ci,IMPLICIT

发条宇

于 2025-05-15 16:25:14 发布

阅读量414

点赞数 3

文章标签： flask django

本文链接：https://blog.csdn.net/eric3012/article/details/147985812

版权

python 执行数据迁移报错
mysql :
1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT

在这里插入图片描述
解决方法：
替换TABLE 后面的表名为你自己的表名，mysql 黑窗口执行。

以下是我的表名，仅作参考
ALTER TABLE book CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_big_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_category_relation CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_chapter_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_chapters CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_shelf CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE book_volume CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE browse_history CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE read_rate CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE search_key_word CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;