背景:用mysql做多表联查时,遇到这种报错:Error running query: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci
解决:
select * from tab1 a left join tab2 b
on a.id=CONVERT(b.id USING utf8) COLLATE utf8_unicode_ci
背景:用mysql做多表联查时,遇到这种报错:Error running query: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci
解决:
select * from tab1 a left join tab2 b
on a.id=CONVERT(b.id USING utf8) COLLATE utf8_unicode_ci