这个SQL语句为什么不能执行成功？

xf_wolf

SQL] SELECT fidsmvt.Flights,airportcode.cityname,fidsmvt.Planstakeo,fidsmvt.actualtake,fidsmvt.expectedla,fidsmvt.DlyMean,fidsmvt.actualland,fidsmvt.Status,fidsmvt.Airlines FROM fidsmvt inner join airportcode on fidsmvt.depairport=airportcode.THREE where fidsmvt.depairport <> 'LZH' order by fidsmvt.planstakeo

[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gb2312_chinese_ci,IMPLICIT) for operation '='
是不是airportcode.cityname的内容是中文，而其它列的内容是英文的原故？如何解决？

eugene_jin

1.(latin1_swedish_ci,IMPLICIT) and (gb2312_chinese_ci,IMPLICIT)

2.FROM fidsmvt inner join airportcode on fidsmvt.depairport=airportcode.THREE

上述原因可以分析出：你这2张表的的字段： fidsmvt.depairport,airportcode.THREE，其字符集校对规则不一致，需要做转换，而且转换之间会出现包容性的问题

Coolriver

可以用show create table 两张表名，就能看出来区别了。

ruochen

l mix of collations (latin1_swedish_ci,IMPLICIT) and (gb2312_chinese_ci,IMPLICIT)


这点英文翻译出来就行了