查看mysql数据编码
登录MySQL服务,查看mysql数据库默认的编码
mysql> show variables like 'character%';
+--------------------------+-------------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | E:\0Develop\mysql-5.7.15-winx64\share\charsets\ |
+--------------------------+-------------------------------------------------+
8 rows in set, 1 warning (0.00 sec)
mysql>
可以看出database和server都采用了latin1编码,不支持中文,我们需要把它修改为utf-8。
除了这两个,其它的如下
| character_set_client | utf8 |