mysql配置没问题，但不显示中文；

Question

mysql>显示类似“%cola%”的变量；
+--------------------+---------------- ---+
|变量名称        |值           |
+--------------------------------+----------------+
|排序规则连接 | utf8_general_ci |
| collat​​ion_database | | utf8_general_ci |
|排序规则服务器     | utf8_general_ci |
+--------------------------------+----------------+

mysql>  显示类似“%char%”的变量；
+--------------------------+--------- ----------------------------------+
|变量名称            |值                                         |
+----------------------------------------+----------------- ------------------------------+
|字符集客户端     | utf8                                          |
|字符集连接 | utf8                                          |
|字符集数据库utf8                                          |
|字符集文件系统 |二进制                                       |
|字符集结果    | utf8                                          |
|字符集服务器     | utf8                                          |
|字符集系统     | utf8                                          |
|字符集_目录       | C:\phpStudy\PHPTutorial\MySQL\share\charsets\ |
+----------------------------+----- ------------------------------------------------------+

mysql>创建表 emp3(
    ->   `id` int(11) NOT NULL AUTO_INCRMENT,
    ->   `username` varchar(50) NOT NULL,
    ->   `balance` float NOT NULL,
    ->   `province` varchar(20) NOT NULL,
    ->   `age` tinyint(3) unsigned NOT NULL,
    ->   `sex` tinyint(4) NOT NULL,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB CHARSET=utf8;
#查询正常，0 行受影响（0.03 秒）

# #

Answer 1

因为cmd命令行的字符编码是gbk,所以你插入的是gbk编码的数据，而你的表是utf8编码，所以插入会乱码，你可以试建一个gbk编码的数据表，执行set names gbk;然后再命令行里插入数据