在mysql中输入show variables like 'char%';
显示如下:| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | gbk
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | gbk
| character_set_system | utf8怎么讲其他几个不是utf8的地方改为utf8啊,最好改了之后就设成默认的了!
显示如下:| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | gbk
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | gbk
| character_set_system | utf8怎么讲其他几个不是utf8的地方改为utf8啊,最好改了之后就设成默认的了!
[mysql]default-character-set=utf8
重新启动MYSQL只对以后建立 的表有用,以前的用MYSQLDUMP备份后,重新建立库、表,导入数据
character_set_database=utf8然后重启mysql服务
重启mysql服务器。