这对我有用。
我使用utf8 charset和utf8_general_ci collation在MySQL 5.5.8上测试了这个。
我尝试搜索where title like '%tèst%'和where title like '%test%',两个查询都返回了“tèst”和“test”,这看起来就像你想要的那样。
这对你不起作用吗?
mysql> create table french (
-> title text
-> ) default charset = utf8, default collate = utf8_general_ci;
Query OK, 0 rows affected (0.13 sec)
mysql>
mysql> insert into french values ('tèst');
Query OK, 1 row affected (0.00 sec)
mysql> insert into french values ('test');
Query OK, 1 row affected (0.00 sec)
mysql> insert into french values ('toast');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> select * from french where title like '%tèst%';
+-------+
| title |
+-------+
| tèst |
| test |
+-------+
2 rows in set (0.00 sec)
mysql> select * from french where title like '%test%';
+-------+
| title |
+-------+
| tèst |
| test |
+-------+
2 rows in set (0.00 sec)