[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 

在查询mysql数据库的时候遇到这个问题，要想查询成功，可以在运行查询语句前，先运行set names 'latin1'.

如：

set names 'latin1';
select * from table where station=‘567890’；