The valid values for collation name and ID, and their descriptions.
|
Collation Name |
Collation ID |
Description |
|---|---|---|
|
default |
20 |
Deafult Unicode multilingual |
|
thaidict |
21 |
Thai dictionary order |
|
iso14651 |
22 |
ISO14651 standard |
|
utf8bin |
24 |
UTF-16 ordering – matches UTF-8 binary ordering |
|
altnoacc |
39 |
CP 850 Alternative – no accent |
|
altdict |
45 |
CP 850 Alternative – lowercase first |
|
altnocsp |
46 |
CP 850 Western European – no case preference |
|
scandict |
47 |
CP 850 Scandinavian – dictionary ordering |
|
scannocp |
48 |
CP 850 Scandinavian – case-insensitive with preference |
|
gbpinyin |
n/a |
GB Pinyin |
|
binary |
50 |
Binary sort |
|
dict |
51 |
Latin-1 English, French, German dictionary |
|
nocase |
52 |
Latin-1 English, French, German no case |
|
nocasep |
53 |
Latin-1 English, French, German no case, preference |
|
noaccent |
54 |
Latin-1 English, French, German no accent |
|
espdict |
55 |
Latin-1 Spanish dictionary |
|
espnocs |
56 |
Latin-1 Spanish no case |
|
espnoac |
57 |
Latin-1 Spanish no accent |
|
rusdict |
58 |
ISO 8859-5 Russian dictionary |
|
rusnocs |
59 |
ISO 8859-5 Russian no case |
|
cyrdict |
63 |
ISO 8859-5 Cyrillic dictionary |
|
cyrnocs |
64 |
ISO 8859-5 Cyrillic no case |
|
elldict |
65 |
ISO 8859-7 Greek dictionary |
|
hundict |
69 |
ISO 8859-2 Hungarian dictionary |
|
hunnoac |
70 |
ISO 8859-2 Hungarian no accents |
|
hunnocs |
71 |
ISO 8859-2 Hungarian no case |
|
turdict |
72 |
ISO 8859-9 Turkish dictionary |
|
turknoac |
73 |
ISO 8859-9 Turkish no accents |
|
turknocs |
74 |
ISO 8859-9 Turkish no case |
|
cp932bin |
129 |
CP932 binary ordering |
|
dynix |
130 |
Chinese phonetic ordering |
|
gb2312bn |
137 |
GB2312 binary ordering |
|
cyrdict |
140 |
Common Cyrillic dictionary |
|
turdict |
155 |
Turkish dictionary |
|
euckscbn |
161 |
EUCKSC binary ordering |
|
gbpinyin |
163 |
Chinese phonetic ordering |
|
rusdict |
165 |
Russian dictionary ordering |
|
sjisbin |
179 |
SJIS binary ordering |
|
eucjisbn |
192 |
EUCJIS binary ordering |
|
big5bin |
194 |
BIG5 binary ordering |
|
sjisbin |
259 |
Shift-JIS binary order |