MySQL utf8_czech_ci与utf8_general_ci [英] MySQL utf8_czech_ci vs utf8_general_ci
问题描述
我有一个主要基于捷克语的应用程序,这就是我们uft8_czech_ci的原因.
I have an application which is mostly based in czech language, that is why we uft8_czech_ci.
给出以下示例:
WHERE `firstName` = 'ales' collate utf8_czech_ci
我找不到结果aleš
(这是捷克的通用名称).当我尝试这个:
I am unable to find result aleš
(which is common czech name). When I try this:
WHERE `firstName` = 'ales' collate utf8_general_ci
成功找到aleš
. MySQL中的utf8_czech_ci
定义不正确吗?我不想只是盲目地开始使用general_ci.
It successfuly finds aleš
. Is the utf8_czech_ci
definition in MySQL incorrect? I don't want to just blindly start using general_ci.
谢谢.
推荐答案
原因是š和s是CZ字母表中的两个不同字母,因此这就是使用utf8_czech_ci
归类时找不到它的原因.
The reason is that š and s are two different letters in CZ alphabet, so that's that's why it's not found when using utf8_czech_ci
collation.
另请参见 http://collation-charts.org/mysql60/mysql604. utf8_general_ci.european.html 和 http://collation-charts.org/mysql60/mysql604.utf8_czech_ci.html
这篇关于MySQL utf8_czech_ci与utf8_general_ci的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!