解决Mysql中文乱码

 

 

1.进入mysql

mysql -uroot -ppasswd   //root和passwd是mysql数据库的用户和密码

2.

mysql >show variables like '%char%'

会出现如下内容

| 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 | /usr/share/mysql/charsets/

8 rows in set (0.00 sec)

 

则此时输入命令

mysql >set character_set_client ='utf8';

mysql >set character_set_connection ='utf8';

mysql >set character_set_database ='utf8';

mysql >set character_set_results ='utf8';

mysql >set character_set_server ='utf8';

即把所有的“latin1”编码换成“utf8”编码

 

注：如果导入mysql的是*.sql文件，则应该保证该sql文件是以utf8格式保存的（用ultraedit保存可以更改为需要的格式的）