MySQL Regexp 点(任意)不匹配重音字符

Question

根据documentation . 应匹配任何字符，但不匹配重音字符。

mysql> select 'test' regexp 't.st';
+----------------------+
| 'test' regexp 't.st' |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)

mysql> select 'tést' regexp 't.st';
+-----------------------+
| 'tést' regexp 't.st'  |
+-----------------------+
|                     0 |
+-----------------------+

我是不是做错了什么，或者无论如何都可以匹配任何字符，包括特殊/重音字符？

我的数据库排序规则是 utf8_general_ci，我在测试查询上使用 collat​​e 命令尝试了一些不同的排序规则，但没有成功。

Answer 1

遵循 MySQL 文档:

Warning

The REGEXP and RLIKE operators work in byte-wise fashion, so they are not multibyte safe and may produce unexpected results with multibyte character sets. In addition, these operators compare characters by their byte values and accented characters may not compare as equal even if a given collation treats them as equal.

所以你不应该这样做。

来源:http://dev.mysql.com/doc/refman/5.0/en/regexp.html