"utf8_unicode_ci"和"utf8_unicode_ci"之间有什么区别?和"utf8_unicode_520_ci" [英] What is the difference between "utf8_unicode_ci" and "utf8_unicode_520_ci"
问题描述
我最近升级了WAMPServer,现在在phpMyAdmin中,我同时看到了排序规则utf8_unicode_ci
和utf8_unicode_520_ci
.我在土耳其语应用程序中使用的是"utf8_unicode_ci",但我想知道新的*_520
归类有何不同?
I recently upgraded WAMPServer and now in phpMyAdmin, I see both collations utf8_unicode_ci
and utf8_unicode_520_ci
. I was using "utf8_unicode_ci" for Turkish applications, but I wonder what is different in the new *_520
collation?
推荐答案
如归类名称中所述:
Unicode归类名称可以包括一个版本号,以指示该归类所基于的Unicode归类算法(UCA)的版本.名称中没有版本号的基于UCA的排序规则使用版本4.0.0 UCA权重键: http://www.unicode.org/Public/UCA/5.2.0/allkeys.txt .
Unicode collation names may include a version number to indicate the version of the Unicode Collation Algorithm (UCA) on which the collation is based. UCA-based collations without a version number in the name use the version-4.0.0 UCA weight keys: http://www.unicode.org/Public/UCA/4.0.0/allkeys-4.0.0.txt. A collation name such as
utf8_unicode_520_ci
is based on UCA 5.2.0 weight keys: http://www.unicode.org/Public/UCA/5.2.0/allkeys.txt.
这篇关于"utf8_unicode_ci"和"utf8_unicode_ci"之间有什么区别?和"utf8_unicode_520_ci"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!