mysql的编码涉及如下:
1.client
2.mysqld
3.mysql
修改默认为utf8
修改my.cnf:
--在 [mysqld] 标签下:default-character-set = utf8character_set_server = utf8--在 [mysql] 标签下:default-character-set = utf8 --在 [client]标签下: default-character-set = utf8
重启服务:
/etc/init.d/mysqld restart
查看编码:
show variables like 'character%';