blocks|key|479744|text|这在极端情况下不起作用，但请尝试将列排序规则更改为UFT8+utf8_unicode_ci。然后，重音字符将与其非重音字符相同。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|479745|entityMap^0|U|F|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

This wont work in extreme circumstances, but try to change the column collation to UFT8 <code>utf8_unicode_ci</code>. Then accented characters will be equal to their non-accented counterparts.

blocks|key|479855|text|您可以在运行时在sql查询中更改排序规则，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|479856|...where+title+like+'%25torun%25'+collate+utf8_general_ci|code-block|syntax|javascript|479857|但要注意，在运行时动态更改排序规则会放弃mysql使用索引的可能性，因此在大型表上的性能可能会很糟糕。|479858|或者，您可以将列复制到另一列，例如searchable_title，但更改其排序规则。实际上，做这种类型的事情是很常见的，在这种情况下，您复制数据，但其格式略有不同，并针对特定的工作负载/目的进行了优化。您可以使用触发器作为保持重复列同步的好方法。如果被索引，这个方法有可能执行得很好。|offset|length|style|CODE|479859|注意-确保你的数据库真的有这些字符，而不是html实体。此外，连接的字符集也很重要。上面假设它被设置为utf8，例如，通过像set+names+utf8这样的set+names|479860|如果不是，则需要文字值的introducer|479861|...where+title+like+_utf8'%25torun%25'+collate+utf8_general_ci|479862|当然，单引号中的值实际上必须是utf8编码的，即使查询的其余部分不是。|479863|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html|1|http://dev.mysql.com/doc/refman/5.0/en/charset-literal.html^0|0|0|0|H|G|0|1Q|E|27|9|0|0|C|A|1|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|19|8|@$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1C|8|@$K|1D|L|1E|M|N]]|9|@$K|1F|L|1G|1|1H]]|A|$]]|$1|Q|3|R|5|6|7|1I|8|@]|9|@$K|1J|L|1K|1|1L]]|A|$]]|$1|S|3|T|5|D|7|1M|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1N|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]|14|$5|Z|10|11|A|$12|15]]]]

You can change the collation at runtime in the sql query,

<pre><code>...where title like '%torun%' collate utf8_general_ci
</code></pre>

but beware that changing the collation on the fly at runtime forgoes the possibility of mysql using an index, so performance on large tables may be terrible.

Or, you can copy the column to another column, such as <code>searchable_title</code>, but change the collation on it. It's actually common to do this type of stuff, where you copy data but have it in some slightly different form that's optimized for some specific workload/purpose. You can use triggers as a nice way to keep the duplicated columns in sync. This method has the potential to perform well, if indexed.

Note - Make sure that your db really has those characters and not html entities.
Also, the character set of your connection matters. The above assumes it's set to utf8, for example, via <a href="http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html">set names</a> like <code>set names utf8</code>

If not, you need an <a href="http://dev.mysql.com/doc/refman/5.0/en/charset-literal.html">introducer</a> for the literal value

<pre><code>...where title like _utf8'%torun%' collate utf8_general_ci
</code></pre>

and of course, the value in the single quotes must actually be utf8 encoded, even if the rest of the sql query isn't.

blocks|key|696024|text|你可以试试SOUNDEX：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|696025|http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex|offset|length|696026|这将根据两个字符串的发音对它们进行比较。但这显然带来了更多的结果。|696027|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|25|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

You could try SOUNDEX:

<a href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_soundex</a>

This compares two string by how they sound. But this obviously delivers many more results.

Is there any way to make search query accent insensitive?

the column's and table's collation are utf8_polish_ci and I don't want to change them.

example word : toruń

<pre><code>select * from pages where title like '%torun%'
</code></pre>

It doesn't find "toruń". How can I do that?

Accent insensitive search query in MySQL

数据库

有没有办法让搜索查询的重音不敏感？列和表的排序规则是utf8_polish_ci，我不想更改它们。示例单词: toruńselect * from pages where title like '%torun%'它找不到"toruń“。我该怎么做呢？

问MySQL中不区分重音的搜索查询
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL中不区分重音的搜索查询EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL中不区分重音的搜索查询
EN