mysql表如下
[color=blue]
mysql> desc sportsreading;
+--------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+----------------+
| id | int(2) | NO | PRI | NULL | auto_increment |
| title | varchar(10) | NO | | NULL | |
| author | varchar(16) | NO | | NULL | |
| info | varchar(24) | NO | | NULL | |
| price | float | NO | | NULL | |
| amount | int(3) | NO | | NULL | |
+--------+-------------+------+-----+---------+----------------+
6 rows in set (0.05 sec)
mysql> select * from sportsreading;
+----+----------+------------------+------------------------+-------+--------+
| id | title | author | info | price | amount |
+----+----------+------------------+------------------------+-------+--------+
| 1 |
队报 | Victor Goddet | found in 1900, France | 10.5 | 200 |
| 2 |
马卡报 | Manuel Fernandes | found in 1938, Spain | 12.5 | 200 |
| 3 |
踢球者 | Rainer Holzschuh | found in 1920, Germany | 11.5 | 200 |
| 4 |
卫报 | Kings Place | found in 1821, England | 15 | 200 |
+----+----------+------------------+------------------------+-------+--------+
4 rows in set (0.00 sec)
[/color]
当我用select * from sportsreading where author='Victor Goddet';等语句时可以搜索到记录。
[color=red][size=medium]但当条件是中文内容时就搜不到了[/size][/color]
[color=blue]
mysql> select * from sportsreading where title='队报';
Empty set (0.00 sec)
[/color]
字段名绝对正确，没有空格，
[color=blue]
mysql> select * from sportsreading where title='%队报%';
Empty set (0.00 sec)
[/color]
[color=red]
[size=medium]请问这是怎么回事啊？ 怎么解决啊？[/size][/color]
在MySQL Command Line Client，可以用下面方式切换为utf8或者gbk：
[code="java"]charset utf[/code]
或者
[code="java"]charset gbk。[/code]
应该没有问题。
把mysql编码方式设置成UTF8试试