寻找不区分大小写的MySQL排序规则，其中"a"表示！=“ä" [英] Looking for case insensitive MySQL collation where "a" != "ä"

问题描述

我正在寻找UTF8的MySQL排序规则，该排序规则不区分大小写，并且区分"a"和ä"(或更一般地，在变音/重音字符及其纯"格式之间进行区分).前者utf8_general_ci起作用，后者utf8_bin机器人都不起作用.如果没有这样的排序规则，该怎么做才能在WHERE子句中尽可能地接近?

I'm looking for a MySQL collation for UTF8 which is case insensitive and distinguishes between "a" and "ä" (or more generally, between umlauted / accented characters and their "pure" form). utf8_general_ci does the former, utf8_bin the latter, bot none does both. If there is no such collation, what can I do to get as close as possible in a WHERE clause?

推荐答案

我的建议是使用utf8_bin，并在WHERE子句中将比较的两端都强制为大写或小写.

My recommendation would be to use utf8_bin and in your WHERE clause, force both sides of your comparison to upper or lower case.

这篇关于寻找不区分大小写的MySQL排序规则，其中"a"表示！=“ä"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！