utf8_unicode_ci与utf8_general_ci的区别

2015-5-12 liyangweb.com 李杨 MySQL

当前,utf8_unicode_ci校对规则仅部分支持Unicode校对规则算法。一些字符还是不能支持。并且,不能完全支持组合的记号。这主要影响越南和俄罗斯的一些少数民族语言,如:Udmurt 、Tatar、Bashkir和Mari。

utf8_unicode_ci的最主要的特色是支持扩展,即当把一个字母看作与其它字母组合相等时。例如,在德语和一些其它语言中‘ß’等于‘ss’。

utf8_general_ci是一个遗留的 校对规则,不支持扩展。它仅能够在字符之间进行逐个比较。这意味着utf8_general_ci校对规则进行的比较速度很快,但是与使用utf8_unicode_ci的校对规则相比,比较正确性较差)。

例如,使用utf8_general_ci和utf8_unicode_ci两种 校对规则下面的比较相等:

Ä = A

Ö = O

Ü = U

两种校对规则之间的区别是,对于utf8_general_ci下面的等式成立:

ß = s

但是,对于utf8_unicode_ci下面等式成立:

ß = ss

对于一种语言仅当使用utf8_unicode_ci排序做的不好时,才执行与具体语言相关的utf8字符集 校对规则。例如,对于德语和法语,utf8_unicode_ci工作的很好,因此不再需要为这两种语言创建特殊的utf8校对规则。

utf8_general_ci也适用与德语和法语,除了‘ß’等于‘s’,而不是‘ss’之外。如果你的应用能够接受这些,那么应该使用utf8_general_ci,因为它速度快。否则,使用utf8_unicode_ci,因为它比较准确。

标签: mysql

评论:

gagnetoo
2019-01-18 19:37
<a href="http://www.irecaconfort.com/air-jordan-14-desert-rosa-noise-butya">air jordan 14 desert rosa noise</a> <a href="http://www.outsourcedbdc.com/nike-pegasus-33-svart-and-hvit-jordans-schuhef">nike pegasus 33 svart and hvit jordans</a> <a href="http://www.pmtraincert.com/mens-ralph-lauren-tank-top-purple-green-poloz">mens ralph lauren tank top purple green</a> <a href="http://www.puyichinese.com/nike-flyknit-lunar-1-hommes-violet-vert-chaussuresa">nike flyknit lunar 1 hommes violet vert</a> <a href="http://www.jacdelaye.com/nike-free-flyknit-5.0-in-esecuzione-scarpe-you-tube-schuhee">nike free flyknit 5.0 in esecuzione scarpe you tube</a> <a href="http://www.jaredfencing.com/nike-free-tr-hvit-r%C3%B8d-scarpea">nike free tr hvit r酶d</a>
gagnetoo http://www.gagnetoo.com/
dishyhair
2019-01-07 08:00
<a href="http://www.geuwompo.com/redskins-washington-new-era-nfl-team-splitter-9fifty-snapback-cap-hatg">redskins washington new era nfl team splitter 9fifty snapback cap</a> <a href="http://www.partyhubuk.com/ray-ban-sunglasses-for-men-round-lens-sunglassesf">ray ban sunglasses for men round lens</a> <a href="http://www.shahsmkj.com/new-adidas-boost-2016-skox">new adidas boost 2016</a> <a href="http://www.wanbilm.com/nike-zoom-pegasus-34-dam%C3%A4nner-schwarz-skoc">nike zoom pegasus 34 dam盲nner schwarz</a> <a href="http://www.dmmsband.com/nike-lebron-13-blue-lagoon-full-movie-skob">nike lebron 13 blue lagoon full movie</a> <a href="http://www.playhousecash.com/adidas-superstar-2-light-blau-shoesv">adidas superstar 2 light blau</a>
dishyhair http://www.dishyhair.com/
associazioneagape
2019-01-04 04:37
<a href="http://www.dietecon.net/adidas-zx-flux-reflective-nero-verde-butye">adidas zx flux reflective nero verde</a> <a href="http://www.digilowcost.net/nike-air-max-87-negro-p%C3%BArpura-scarped">nike air max 87 negro p煤rpura</a> <a href="http://www.digitalgoldrush.net/zoom-kobe-6-zapatos-schuhea">zoom kobe 6 zapatos</a> <a href="http://www.dimaf.net/adidas-prossoator-instinct-fg-tutti-bianca-kurpesb">adidas prossoator instinct fg tutti bianca</a> <a href="http://www.dionamago.net/nike-kobe-9-mennns-sko-schuhef">nike kobe 9 mennns sko</a> <a href="http://www.disorderedliberty.net/air-jordan-3-retro-nero-and-bianca-butye">air jordan 3 retro nero and bianca</a>
associazioneagape http://www.associazioneagape.net/
ankaralokanta
2019-01-03 07:20
<a href="http://www.acforlessllc.com/kvinners-nike-sb-stefan-janoski-max-gr%C3%B8nn-gr%C3%A5-kurpesa">kvinners nike sb stefan janoski max gr酶nn gr氓</a> <a href="http://www.thehodostore.com/adidas-damian-lillard-grey-brown-sneakerb">adidas damian lillard grey brown</a> <a href="http://www.gandoff.com/nike-cortez-shark-low-black-shoesg">nike cortez shark low black</a> <a href="http://www.langbenlang.com/neymar-jordan-snapback-hats">neymar jordan snapback</a> <a href="http://www.glennloovens.com/nike-dunk-sneakers-pokemon-sneakerf">nike dunk sneakers pokemon</a> <a href="http://www.kamilotomotiv.com/air-jordan-3-infrarot-23-for-verkauf-obuvc">air jordan 3 infrarot 23 for verkauf</a>
[url=http://www.ankaralokanta.com/]ankaralokanta[/url]
pubtabata
2018-12-29 07:50
<a href="http://www.turkayambalaj.com/nfl-womens-nike-new-york-jets-97-nathan-shepherd-green-name-number-logo-long-sleeve-t-shirt-nflx">nfl womens nike new york jets 97 nathan shepherd green name number logo long sleeve t shirt</a> <a href="http://www.wensemble.com/nike-air-max-97-marrone-gun-kurpesc">nike air max 97 marrone gun</a> <a href="http://www.coldwaterapps.com/womens-joe-staley-jersey-red-nike-t-shirt-nfl-san-francisco-49ers-74-name-number-logo-nflz">womens joe staley jersey red nike t shirt nfl san francisco 49ers 74 name number logo</a> <a href="http://www.enescomert.com/adidas-zx-700-himmelbl%C3%A5-obuvd">adidas zx 700 himmelbl氓</a> <a href="http://www.evelynreynoso.com/kyrie-2-blanc-bleu-rouge-scarpec">kyrie 2 blanc bleu rouge</a> <a href="http://www.michsmallbiz.com/adidas-tubular-runner-primeknit-bl%C3%A5-sort-kurpesb">adidas tubular runner primeknit bl氓 sort</a>
pubtabata http://www.pubtabata.com/

发表评论:

Powered by emlog 冀ICP备13011830号-1