Character_set_client:character_set_client: The character set used by the client source data
Character_set_connection: Connection Layer Character Set
Character_set_results: Query result Character Set
The settings of the above three variables are only valid for the current client, for example, I am connected to the win command line MySQL, I set the setting character_set_connection = UTF8;
When I start another command line connected to the database, this character_set_connection is not necessarily utf8, the command line character_set_connection variable is the default setting GBK.
The Character_set_results is set to
Http://blog.sina.com.cn/s/blog_6fee15b40100oo6q.html
http://bbs.csdn.net/topics/300122246
Http://www.cnblogs.com/discuss/articles/1862248.html
Https://www.cnblogs.com/lazyno/archive/2015/02/07/4278544.html
MySQL Character set