After I changed both table collition into
utf8mb4_unicode_ci, the database still show this error:
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
when I execute this query:
select * from zl_report_user where union_id not in( select distinct unionid from wechat_user )
should I restart the MySQL 5.7 to make it take effect? I restart the MySQL still did not work. what should I do to avoid this problem? I also tried this way:
ALTER DATABASE `zhuolian-report-fat` CHARACTER SET utf8 COLLATE utf8_unicode_ci;
still did not work.