Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for opera

MySQL 异常提示排序规则编码混乱，mysql 8 之后的默认 COLLATE 为 utf8mb4_0900_ai_ci。

Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for opera

如果是 MySQL 8 之前，针对表字段修改字符集：

alter table xxx_table convert to character set utf8mb4 collate utf8mb4_general_ci;

针对表修改字符集：

或者

alter table xxx_table  default character set utf8mb4 collate=utf8mb4_general_ci;