Character Set (CHARACTER set) and proofing Set (COLLATE)

Http://blog.sina.com.cn/s/blog_9707fac301016wxm.html

Http://www.th7.cn/db/mysql/201412/84636.shtml

From the above, we can see that character_set_connection, Character_set_client, character_set_results three character sets when used. As you can actually see, when a client connects to a server, it sends its desired character set name to the MySQL server, which is then used by the server to set Character_set_connection, Character_set_client, Character_set_results these three values. such as CMD is used with GBK, while MySQL Workbench is used with UTF8.

Character Set (CHARACTER set) and proofing Set (COLLATE)