修改Mysql编码

1.查询mysql编码的命令 show variables like '%char%'

会查看到以下信息

+--------------------------+---------------------------------------------------------------+
| Variable_name                        | Value       |
+--------------------------+---------------------------------------------------------------+
| character_set_client               | utf8           |
| character_set_connection     | utf8           |
| character_set_database        | utf8           |
| character_set_filesystem      | binary       |
| character_set_results            | utf8           |
| character_set_server             | utf8           |
| character_set_system           | utf8           |
| character_sets_dir                 | C:\Program Files (x86)\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------------+

修改编码: set character_set_client=utf8;

原文来自:http://blog.csdn.net/char_cn/article/details/7954184