mysql error 1267

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(