On this page本页内容
New in version 3.4.版本3.4中的新功能。
Collation排序规则 allows users to specify language-specific rules for string comparison, such as rules for lettercase and accent marks.允许用户为字符串比较指定特定于语言的规则,例如字母大小写和重音符号的规则。
Some collation locales have variants, which employ special language-specific rules. 一些排序规则区域设置有变体,它们使用特定于语言的特殊规则。To specify a locale variant, use the following syntax:要指定区域设置变量,请使用以下语法:
For example, to use the 例如,要使用中文排序规则的unihan
variant of the Chinese collation:unihan
变体:
See the collation page for a full description of collation behavior and syntax.有关排序规则行为和语法的完整描述,请参阅排序规则页面。
MongoDB’s collation feature supports the following languages. MongoDB的排序规则功能支持以下语言。The following table lists the supported languages and the associated locales as defined by ICU Locale ID. 下表列出了受支持的语言以及ICU Locale ID定义的相关语言环境。[1]
|
|
Tip
To explicitly specify simple binary comparison, specify 要显式指定简单二进制比较,请指定locale
value of "simple"
."simple"
的locale
(区域设置)值。
[1] |
A collation document contains several optional parameters in addition to the required 除了必需的locale
parameter. locale
参数外,排序规则文档还包含几个可选参数。Depending on which 根据您使用的默认locale
you use, the default parameters may be different. locale
参数可能不同。See the collation page for a full description of collation syntax.有关排序规则语法的完整描述,请参阅排序规则页面。
The following default parameters are consistent across all locales:以下默认参数在所有地区都是一致的:
caseLevel : false
strength : 3
numericOrdering : false
maxVariable : punct
The following table shows the default collation parameters which may vary across different locales:下表显示了默认排序规则参数,这些参数在不同的地区可能有所不同:
Locale | caseFirst | alternate | normalization | backwards |
---|---|---|---|---|
af | off | non-ignorable | FALSE | FALSE |
sq | off | non-ignorable | FALSE | FALSE |
am | off | non-ignorable | FALSE | FALSE |
ar | off | non-ignorable | FALSE | FALSE |
ar@collation=compat | off | non-ignorable | FALSE | FALSE |
hy | off | non-ignorable | FALSE | FALSE |
as | off | non-ignorable | TRUE | FALSE |
az | off | non-ignorable | FALSE | FALSE |
az@collation=search | off | non-ignorable | TRUE | FALSE |
be | off | non-ignorable | FALSE | FALSE |
bn | off | non-ignorable | TRUE | FALSE |
bn@collation=traditional | off | non-ignorable | TRUE | FALSE |
bs | off | non-ignorable | FALSE | FALSE |
bs@collation=search | off | non-ignorable | TRUE | FALSE |
bs_Cyrl | off | non-ignorable | FALSE | FALSE |
bg | off | non-ignorable | FALSE | FALSE |
my | off | non-ignorable | TRUE | FALSE |
ca | off | non-ignorable | FALSE | FALSE |
ca@collation=search | off | non-ignorable | TRUE | FALSE |
chr | off | non-ignorable | FALSE | FALSE |
zh | off | non-ignorable | FALSE | FALSE |
zh@collation=big5han | off | non-ignorable | FALSE | FALSE |
zh@collation=gb2312han | off | non-ignorable | FALSE | FALSE |
zh@collation=unihan | off | non-ignorable | FALSE | FALSE |
zh@collation=zhuyin | off | non-ignorable | FALSE | FALSE |
zh_Hant | off | non-ignorable | FALSE | FALSE |
hr | off | non-ignorable | FALSE | FALSE |
hr@collation=search | off | non-ignorable | TRUE | FALSE |
cs | off | non-ignorable | FALSE | FALSE |
cs@collation=search | off | non-ignorable | TRUE | FALSE |
da | upper | non-ignorable | FALSE | FALSE |
da@collation=search | off | non-ignorable | TRUE | FALSE |
nl | off | non-ignorable | FALSE | FALSE |
dz | off | non-ignorable | FALSE | FALSE |
en | off | non-ignorable | FALSE | FALSE |
en_US_POSIX | off | non-ignorable | FALSE | FALSE |
en_US | off | non-ignorable | FALSE | FALSE |
eo | off | non-ignorable | FALSE | FALSE |
et | off | non-ignorable | FALSE | FALSE |
ee | off | non-ignorable | FALSE | FALSE |
fo | off | non-ignorable | FALSE | FALSE |
fo@collation=search | off | non-ignorable | TRUE | FALSE |
fil | off | non-ignorable | FALSE | FALSE |
fi | off | non-ignorable | FALSE | FALSE |
fi@collation=search | off | non-ignorable | TRUE | FALSE |
fi@collation=traditional | off | non-ignorable | FALSE | FALSE |
fr | off | non-ignorable | FALSE | FALSE |
fr_CA | off | non-ignorable | FALSE | TRUE |
gl | off | non-ignorable | FALSE | FALSE |
gl@collation=search | off | non-ignorable | TRUE | FALSE |
ka | off | non-ignorable | FALSE | FALSE |
de | off | non-ignorable | FALSE | FALSE |
de@collation=search | off | non-ignorable | TRUE | FALSE |
de@collation=phonebook | off | non-ignorable | FALSE | FALSE |
de@collation=eor | off | non-ignorable | FALSE | FALSE |
de_AT | off | non-ignorable | FALSE | FALSE |
de_AT@collation=phonebook | off | non-ignorable | FALSE | FALSE |
el | off | non-ignorable | TRUE | FALSE |
gu | off | non-ignorable | TRUE | FALSE |
ha | off | non-ignorable | FALSE | FALSE |
haw | off | non-ignorable | FALSE | FALSE |
he | off | non-ignorable | TRUE | FALSE |
he@collation=search | off | non-ignorable | TRUE | FALSE |
hi | off | non-ignorable | TRUE | FALSE |
hu | off | non-ignorable | FALSE | FALSE |
is | off | non-ignorable | FALSE | FALSE |
is@collation=search | off | non-ignorable | TRUE | FALSE |
ig | off | non-ignorable | TRUE | FALSE |
smn | off | non-ignorable | FALSE | FALSE |
smn@collation=search | off | non-ignorable | TRUE | FALSE |
id | off | non-ignorable | FALSE | FALSE |
ga | off | non-ignorable | FALSE | FALSE |
it | off | non-ignorable | FALSE | FALSE |
ja | off | non-ignorable | FALSE | FALSE |
ja@collation=unihan | off | non-ignorable | FALSE | FALSE |
kl | off | non-ignorable | FALSE | FALSE |
kl@collation=search | off | non-ignorable | TRUE | FALSE |
kn | off | non-ignorable | TRUE | FALSE |
kn@collation=traditional | off | non-ignorable | TRUE | FALSE |
kk | off | non-ignorable | FALSE | FALSE |
km | off | non-ignorable | TRUE | FALSE |
kok | off | non-ignorable | TRUE | FALSE |
ko | off | non-ignorable | FALSE | FALSE |
ko@collation=search | off | non-ignorable | TRUE | FALSE |
ko@collation=searchjl | off | non-ignorable | TRUE | FALSE |
ko@collation=unihan | off | non-ignorable | FALSE | FALSE |
ky | off | non-ignorable | FALSE | FALSE |
lkt | off | non-ignorable | FALSE | FALSE |
lo | off | non-ignorable | FALSE | FALSE |
lv | off | non-ignorable | FALSE | FALSE |
ln | off | non-ignorable | FALSE | FALSE |
ln@collation=phonetic | off | non-ignorable | FALSE | FALSE |
lt | off | non-ignorable | FALSE | FALSE |
dsb | off | non-ignorable | FALSE | FALSE |
lb | off | non-ignorable | FALSE | FALSE |
mk | off | non-ignorable | FALSE | FALSE |
ms | off | non-ignorable | FALSE | FALSE |
ml | off | non-ignorable | FALSE | FALSE |
mt | upper | non-ignorable | FALSE | FALSE |
mr | off | non-ignorable | TRUE | FALSE |
mn | off | non-ignorable | FALSE | FALSE |
ne | off | non-ignorable | FALSE | FALSE |
se | off | non-ignorable | FALSE | FALSE |
se@collation=search | off | non-ignorable | TRUE | FALSE |
nb | off | non-ignorable | FALSE | FALSE |
nb@collation=search | off | non-ignorable | TRUE | FALSE |
nn | off | non-ignorable | FALSE | FALSE |
nn@collation=search | off | non-ignorable | TRUE | FALSE |
or | off | non-ignorable | TRUE | FALSE |
om | off | non-ignorable | FALSE | FALSE |
ps | off | non-ignorable | TRUE | FALSE |
fa | off | non-ignorable | TRUE | FALSE |
fa_AF | off | non-ignorable | TRUE | FALSE |
pl | off | non-ignorable | FALSE | FALSE |
pt | off | non-ignorable | FALSE | FALSE |
pa | off | non-ignorable | TRUE | FALSE |
ro | off | non-ignorable | FALSE | FALSE |
ru | off | non-ignorable | FALSE | FALSE |
sr | off | non-ignorable | FALSE | FALSE |
sr_Latn | off | non-ignorable | FALSE | FALSE |
sr_Latn@collation=search | off | non-ignorable | TRUE | FALSE |
si | off | non-ignorable | TRUE | FALSE |
si@collation=dictionary | off | non-ignorable | TRUE | FALSE |
sk | off | non-ignorable | FALSE | FALSE |
sk@collation=search | off | non-ignorable | TRUE | FALSE |
sl | off | non-ignorable | FALSE | FALSE |
es | off | non-ignorable | FALSE | FALSE |
es@collation=search | off | non-ignorable | TRUE | FALSE |
es@collation=traditional | off | non-ignorable | FALSE | FALSE |
sw | off | non-ignorable | FALSE | FALSE |
sv | off | non-ignorable | FALSE | FALSE |
sv@collation=search | off | non-ignorable | TRUE | FALSE |
ta | off | non-ignorable | TRUE | FALSE |
te | off | non-ignorable | TRUE | FALSE |
th | off | shifted | TRUE | FALSE |
bo | off | non-ignorable | FALSE | FALSE |
to | off | non-ignorable | FALSE | FALSE |
tr | off | non-ignorable | FALSE | FALSE |
tr@collation=search | off | non-ignorable | TRUE | FALSE |
uk | off | non-ignorable | FALSE | FALSE |
hsb | off | non-ignorable | FALSE | FALSE |
ur | off | non-ignorable | FALSE | FALSE |
ug | off | non-ignorable | FALSE | FALSE |
vi | off | non-ignorable | TRUE | FALSE |
vi@collation=traditional | off | non-ignorable | TRUE | FALSE |
wae | off | non-ignorable | FALSE | FALSE |
cy | off | non-ignorable | FALSE | FALSE |
yi | off | non-ignorable | TRUE | FALSE |
yi@collation=search | off | non-ignorable | TRUE | FALSE |
yo | off | non-ignorable | TRUE | FALSE |
zu | off | non-ignorable | FALSE | FALSE |