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;