alter table table_name convert to character set utf8 collate utf8_general_ci;
ERROR 1267 (HY000): Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=’
Leave a reply
alter table table_name convert to character set utf8 collate utf8_general_ci;