今天LEFT JOIN 表，報(bào)如下錯誤：
1267-Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLIC for operation '=')
出現(xiàn)這種問題就是關(guān)聯(lián)表的字符集不匹配
1.查看數(shù)據(jù)庫的字符集
show variables where Variable_name like 'collation%';
結(jié)果：
![]()
image
image
2.查看關(guān)聯(lián)表字符集
show create table table_name;
3.給關(guān)聯(lián)表設(shè)置字符編碼
alter table table_name default character set utf8mb4 collate=utf8mb4_general_ci;
4.給關(guān)聯(lián)表字段設(shè)置字符編碼
ALTER TABLE table_name convert to CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
