参考这篇文章:https://lzw.me/a/mysql-charset.html
还有一篇官方文档:https://dev.mysql.com/doc/refman/5.7/en/charset.html
show variables like "%char%"; set names utf8; set character_set_server = utf8;
MYSQL两个数据库字符集保持一致问题
原文:http://www.cnblogs.com/rgqancy/p/6782305.html