1.查看数据库当前的编码格式
命令: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 | G:\myenv\mysql-5.6.21\share\charsets\ |
+--------------------------+---------------------------------------+
2.根据上一步,修改character_set_database和character_set_server的字符集
(1)方法一
命令:set character_set_database = gbk;
set character_set_server = gbk;
(2)方法二
修改数据库配置文件 my.ini
在[mysqld]组中添加语句 character_set_server=gbk
重启mysql服务(不是重启操作窗口的意思)
3.再次查看数据库当前的编码格式
+--------------------------+---------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | G:\myenv\mysql-5.6.21\share\charsets\ |
+--------------------------+---------------------------------------+
注:character_set_system是元数据的编码,无需修改
本人的mysql数据库版本是5.6.21