按照http://blog.csdn.net/yynetsdk/article/details/6923940这篇帖子,以及http://helloworlda.iteye.com/blog/1275160这篇帖子,修改MySQL数据库的默认编码我修改my.ini配置文件,如...
按照http://blog.csdn.net/yynetsdk/article/details/6923940 这篇帖子,以及http://helloworlda.iteye.com/blog/1275160 这篇帖子,修改MySQL数据库的默认编码
我修改my.ini配置文件,如下:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
explicit_defaults_for_timestamp = TRUE
重启服务后,查看系统变量:
mysql> show variables like 'character%';
+--------------------------+-------------
| Variable_name | Value
+--------------------------+-------------
| character_set_client | gbk
| character_set_connection | gbk
| character_set_database | utf8
| character_set_filesystem | binary
| character_set_results | gbk
| character_set_server | utf8
| character_set_system | utf8
按道理来说,character_set_client,character_set_connection,character_set_results也应该被修改为utf8才对,但是没有改成功。很诡异……
各位高手觉得哪里出了问题?
展开