MySql Illegal mix of collations (utf8_croatian_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

两个表连接查询的时候字段比对出错了。

SQL:

 SELECT * FROM a EFT JOIN  m ON a.StepUser=m.`UserName`

 

出错信息：

1 queries executed, 0 success, 1 errors, 0 warnings

查询：select * from user_flow_step_pack left join `user_center`.`members` m on user_flow_step_pack.StepUser=m.`UserName` LIMIT 0, 1000

错误代码： 1267
Illegal mix of collations (utf8_croatian_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

执行耗时 : 0 sec
传送时间 : 0 sec
总耗时 : 0.856 sec

 

 

SHOW CREATE TABLE user_flow_step_pack

--原始的结构

`StepUser` VARCHAR(50) COLLATE utf8_croatian_ci DEFAULT NULL COMMENT '具体用户'

--需要修改的结构（红色的删除掉）

ALTER TABLE user_flow_step_pack 
CHANGE `StepUser` `StepUser` VARCHAR(50) DEFAULT NULL COMMENT '具体用户'