mysql无法显示中文数据,不是乱码
我使用的是mysql5.1版本的,编码设置为GBK,在查询数据时,中文的数据没有显示。
效果如下示:(realname字段中的数据为中文)
mysql> select * from player_info;
+----------+----------+----------+
| username | password | realname |
+----------+----------+----------+
| user | user | |
+----------+----------+----------+
1 row in set (0.00 sec)
字段realname输入的是中文数据,可是就是看不到数据,问下谁知道是什么原因?
表的描述:
mysql> describe player_info;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| username | varchar(20) | NO | PRI | NULL | |
| password | varchar(20) | NO | | NULL | |
| realname | varchar(20) | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
数据库编码设置:
mysql> show variables like 'char%';
+--------------------------+-------------------------------------------+
| Variable_name | Value |
+--------------------------+-------------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:\MySQL\MySQL Server 5.1\share\charsets\ |
+--------------------------+-------------------------------------------+
8 rows in set (0.00 sec)
不知道谁能给小弟解答到底是何原因造成的?