加班狗 --! 凌晨四点,还在为《黑暗之光HD》CB1做准备。
+--------------------------+-----------------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /opt/udb/program/mysql/mysql-5.5.24/share/charsets/ |
原数据库字符集格式:
mysql> show variables like 'character%';+--------------------------+-----------------------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /opt/udb/program/mysql/mysql-5.5.24/share/charsets/ |
+--------------------------+-----------------------------------------------------+
执行insert插入中文字符后,在列表显示无误。
mysql> select * from server_list;
+----+--------------+
| id | server_name
+----+--------------+
| 1 | 公测239服 |
通过代码查询输出后显示中文乱码。
解决办法:
将 character_set_connection 、character_set_results 的value设置为utf8编码格式。
mysql> set character_set_connection=utf8;
mysql> set character_set_results=utf8;