mysql 客户端连接报错Illegal mix of collations for operation

服务端用的是utf-8，客户端工具打开表和视图是会报Illegal mix of collations for operation错误，经排查，可以采用以下语句解决

 
SET character_set_connection ='gbk'

 
SET character_set_client  ='gbk'