服务端用的是utf-8，客户端工具打开表和视图是会报Illegal mix of collations for operation错误，经排查，可以采用以下语句解决
SET character_set_connection ='gbk'
SET character_set_client ='gbk'
相关文章
- 07-15MySQL查询时报错Illegal mix of collations
- 07-15有关mysql的utf8和utf8mb4，以及Illegal mix of collations for operation 'like'
- 07-15MySQL Error: Illegal mix of collations for operation 'concat'
- 07-15mysql5.6修改字符编码，ERR：Illegal mix of collations for operation 'concat'
- 07-15mysql提示:Illegal mix of collations for operation ‘UNION’
- 07-15mysql进行like查询时报错Illegal mix of collations for operation 'like'
- 07-15MySql查询报错：Illegal mix of collations
- 07-15MySql查询报错：Illegal mix of collations
- 07-15mysql提示:Illegal mix of collations for operation ‘UNION’
- 07-15mysql: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '= 的解决