如果MySQL命令报错: MySql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ 请尝试执行下面的命令: alter table `dbname`.`tablename` convert to character set utf8 collate utf8_general_ci; 如果想要执行全部table,可以参考: Terminal – Convert all MySQL tables and fields to UTF8 mysql --database=dbn… Read More