mysql error 1267_error code: 1267. illegal mix of collations (utf8m

作者：凡人多烦事01 | 2024-05-07 08:38:12

踩

error code: 1267. illegal mix of collations (utf8mb4_unicode_ci,implicit) an

Error Code: 1267. Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’ 0.015 sec

错误原因：关联表的相同字段的编码不一致导致的错误

示例：

# 创建表 t1
create table t1(
 id int(11) PRIMARY KEY auto_increment,
 name varchar(25),
 age varchar(20),
 common varchar(25) collate utf8mb4_unicode_ci default null comment '桥梁'
 );

insert into t1 (name,age,common) values("刘德华","57"1
2
3
4
5
6
7
8
9

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/凡人多烦事01/article/detail/548265