mysql报错1267 - Illegal mix of collations

错误

报错1267 - Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_german2_ci,IMPLICIT) for operation '='

解决

1、统一修改 数据库排序规则

ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci;

2、修改关联字段一致

ALTER TABLE 表A CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci;
ALTER TABLE 表B CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci;