1267, “Illegal mix of collations (latin1_swedish_ci,IMPLICIT

原创于 2025-05-15 16:25:14 发布 · 469 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#flask #django

部署运行你感兴趣的模型镜像

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;

您可能感兴趣的与本文相关的镜像