####################################
#Date: 2011-01-13 By Gary Ding
####################################
[client]
default-character-set = utf8
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
default-character-set = utf8
show variables like 'character%';
设置编码后,数据库需要重建,重新把数据导进来,ok.
/etc/init.d/mysql restart
create database dys2 character set utf8;
或者直接create database dys2 ;
也可以将其全部更改为gb2312 ,一样正常显示。