eg:Select * from 数据库A.表A where name not in (select name from 数据库B.表B)
出现 :[color=red]Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' [/color]
错误警告
解决办法:
[color=blue]Select * from 数据库A.表A where convert(name using utf8) not in (select convert(name using utf8) from 数据库B.表B)[/color]
出现 :[color=red]Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' [/color]
错误警告
解决办法:
[color=blue]Select * from 数据库A.表A where convert(name using utf8) not in (select convert(name using utf8) from 数据库B.表B)[/color]