mysql中文显示？问题

2019独角兽企业重金招聘Python工程师标准>>>

使用命令查看数据库的字符编码: mysql> show variables like 'char%';

+--------------------------+----------------------------------------------------
-----+
| 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:/Program Files/MySQL/MySQL Server 5.5/share/chars
ets/ |
+--------------------------+----------------------------------------------------
-----+

 

发现数据库的编码为: latin1(MYSQL默认字符编码); 

 

将MYSQL数据库同一设置成: gbk格式, 命令如下:

MYSQL>set character_set_client = 'gbk' ;

MYSQL>set character_set_connection = 'gbk' ;

MYSQL>set character_set_results= 'gbk' ;

MYSQL>set character_set_server= 'gbk' ;

 

 

完成之后,执行mysql> show variables like 'char%';
+--------------------------+----------------------------------------------------
-----+
| 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       | D:/Program Files/MySQL/MySQL Server 5.5/share/chars
ets/ |

 

 

 然后修改对应的数据表的字符编码:  alter table map_data modify province varchar(32) character set gbk;

 

转载于:https://my.oschina.net/zhangxu0512/blog/190734