mysql 字符集设置

mysql> show variables like "char%";  
mysql> show variables like "collation%";  
mysql> set character_set_server=utf8;  
mysql> set collation_server=utf8_general_ci; 

mysql> alter table xxx default character set utf8 collate utf8_general_ci;