Mysql更新插入编码问题
数据插入更新,尤其是遇到遗留系统时,编码不一致可能会报错,如Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’
解决方式代码如下:
UPDATE college_video a, colleges b SET a.college_id = b.id WHERE a.college_name_cn COLLATE utf8mb4_unicode_ci = b.name_cn