在windows下安装Mysql,因为失误未选择编码格式,使用了默认的编码格式
导致插入数据时出现编码问题
开启
进入
修改前先停止mysql服务
修改my.ini配置中添加
[client] 下面添加一行 default-character-set=utf8,如下:
[mysqld]
character-set-server = utf8
[mysqld] 下面添加一行 character-set-server=utf8,如下:
[mysqld]
character-set-server=utf8
启动mysql
- 查看是否更改成功
进入myslq Command Line Client,输入show variables like ‘%character%’;
mysql> show variables like ‘%character%’;
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.7\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set, 1 warning (0.00 sec)
修改成功。