让mysql查询支持中文

来源：互联网发布：电子商务美工岗位职责编辑：程序博客网时间：2024/05/22 05:12

问题描述如下：

insert into tb_user values(3,"chen","123","男","who","me","xxx@xxx.com");

而利用"select * from tb_user;"语句进行查看时结果却是：

+----+--------------+-------------+-----+------------+----------+------------------+
| id   | username | password | sex | question | answer | email            |
+----+--------------+-------------+-----+------------+----------+------------------+
| 1   | mr            | 123           | ?   | who        | me        | xxx@xxx.com |
| 2   | koma        | 123            | ?    | who        | me       | xxx@xxx.com |
+----+-------------+--------------+-----+------------+----------+------------------+

发现性别一栏全是"?"

问题的解决：

将my.ini文件中的默认字符集改为gb2312即可
具体的办法是修改其中的[mysqld] 里添加一行： default-character-set=gb2312
然后重启服务,不过只对修改后的数据有效,对修改前已经在数据库中的数据是没有效果的.
如果是临时更改的话,在命令行输入下面信息即可:
SET character_set_client = gb2312;
SET character_set_connection = gb2312;
SET character_set_database = gb2312;
SET character_set_results = gb2312;
SET character_set_server = gb2312;

END