部分转自高人博文
MySQL默认编码是latin1
mysql> show variables like 'character%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:/MySQL/share/charsets/ |
+--------------------------+--------------------------+
my.ini（MySQL配置文件）文件对编码进行修改
设置MySQL的默认字符集为GBK，找到客户端配置[client]在下面添加。
default-character-set=GBK(这是因为，命令行工具默认为GBK)
找到服务器配置[mysqld]在下面添加
default-character-set=utf8
设定MySQL数据库以utf8编码运行，连接MySQL数据库时使用utf8编码
停止和重新启动MySQL
net stop mysql
net start mysql
修改后为
mysql> show variables like 'character%';
+--------------------------+--------------------------+
| Variable_name | Value |
+--------------------------+--------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:/MySQL/share/charsets/ |
+--------------------------+--------------------------+
1504
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
