mysql 中文条件_mysql 以中文内容作为搜索条件时，搜不到的记录的问题。

mysql表如下mysql>descsportsreading;+--------+-------------+------+-----+---------+----------------+|Field|Type|Null|Key|Default|Extra|+--------+-------------+------+-----...

mysql表如下

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)

当我用select * from sportsreading where author='Victor Goddet';等语句时可以搜索到记录。

但当条件是中文内容时就搜不到了

mysql> select * from sportsreading where title='队报';

Empty set (0.00 sec)

字段名绝对正确，没有空格，

mysql> select * from sportsreading where title='%队报%';

Empty set (0.00 sec)

请问这是怎么回事啊？ 怎么解决啊？

展开