MySQL查询异常 — Illegal mix of collations
select
*
from
activity_person person
left join activity_info info
on info.serial_num = person.serial_num;
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '='
查询语句中,,如上异常为两个表的编码格式不同,导致同为varc
原创
2022-02-08 11:01:00 ·
1955 阅读 ·
0 评论