mysql错误提示Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

1.修改表编码

ALTER TABLE 表名 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

2.修改字段的编码：

ALTER TABLE 表名 CHANGE `列明` `列明` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

 

通过以上两个步骤可以解决上述Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)错误