问题描述如下:
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