Sort Order IDs

These tables show the sort order ID for each Microsoft® SQL Server™ sort order. Each sort order is applicable to one character set only. Each table lists the available sort orders for the listed character set.

1252 ISO character set

ID Name Description
50 bin_iso_1 Binary order
51 dictionary_iso Dictionary order, case-sensitive
52 nocase_iso Dictionary order, case-insensitive
53 nocasepref_iso Dictionary order, case-insensitive, uppercase preference
54 noaccents_iso Dictionary order, case-insensitive, accent-insensitive
71 dictionary_1252 Latin-1 case-sensitive
72 nocase_1252 Latin-1 case-insensitive
183 danno_nocasepref Danish/Norwegian dictionary order, case-insensitive, uppercase preference
184 svfi1_nocasepref Swedish/Finnish (Standard) dictionary order, case-insensitive, uppercase preference
185 svfi2_nocasepref Swedish/Finnish (Phone) dictionary order, case-insensitive, uppercase preference
186 islan_nocasepref Icelandic dictionary order, case-insensitive, uppercase preference

850 Multilingual

ID Name Description
40 bin_cp850 Binary order
41 dictionary_850 Dictionary order, case-sensitive
42 nocase_850 Dictionary order, case-insensitive
43 nocasepref_850 Dictionary order, case-insensitive, uppercase preference
44 noaccents_850 Dictionary order, case-insensitive, accent-insensitive
49 caseless_34 Strict compatibility with version 1.x case-insensitive databases
55 alt_dictionary Alternate dictionary order, case-sensitive
56 alt_nocasepref Alternate dictionary order, case-insensitive, uppercase preference
57 alt_noaccents Alternate dictionary order, case-insensitive, accent-insensitive
58 scand_nocasepref Scandinavian dictionary order, case-insensitive, uppercase preference
59 scand_dictionary Scandinavian dictionary order, case-sensitive
60 scand_nocase Scandinavian dictionary order, case-insensitive
61 alt_nocase Alternate dictionary order, case-insensitive

437 U.S. English

ID Name Description
30 bin_cp437 Binary order
31 dictionary_437 Dictionary order, case-sensitive
32 nocase_437 Dictionary order, case-insensitive
33 nocasepref_437 Dictionary order, case-insensitive, uppercase preference
34 noaccents_437 Dictionary order, case-insensitive, accent-insensitive

874 Thai

ID Name Description
204 bin_cp874 Binary order
205 nls_cp874 Dictionary order, case-insensitive
(Microsoft Windows NT® provided)
206 nls_cp874_cs Dictionary order, case-sensitive

932 Japanese

ID Name Description
192 bin_cp932 Binary order
193 nls_cp932 Dictionary order, case-insensitive
(Windows NT provided)
200 nls_cp932_cs Dictionary order, case-sensitive

936 Chinese (simplified)

ID Name Description
198 bin_cp936 Binary order
199 nls_cp936 Dictionary order, case-insensitive
(Windows NT provided)
203 nls_cp936_cs Dictionary order, case-sensitive

949 Korean

ID Name Description
194 bin_cp949 Binary order
195 nls_cp949 Dictionary order, case-insensitive
(Windows NT provided)
201 nls_cp949_cs Dictionary order, case-sensitive

950 Chinese (traditional)

ID Name Description
196 bin_cp950 Binary order
197 nls_cp950 Dictionary order, case-insensitive
(Windows NT provided)
202 nls_cp950_cs Dictionary order, case-sensitive

1250 Central European

ID Name Description
80 bin_cp1250 Binary order
81 dictionary_1250 Dictionary order, case-sensitive
82 nocase_1250 Dictionary order, case-insensitive
83 csydic Czech dictionary order, case-sensitive
84 csync Czech dictionary order, case-insensitive
85 hundic Hungarian dictionary order, case-sensitive
86 hunnc Hungarian dictionary order, case-insensitive
87 plkdic Polish dictionary order, case-sensitive
88 plknc Polish dictionary order, case-insensitive
89 romdic Romanian dictionary order, case-sensitive
90 romnc Romanian dictionary order, case-insensitive
91 shldic Croatian dictionary order, case-sensitive
92 shlnc Croatian dictionary order, case-insensitive
93 skydic Slovak dictionary order, case-sensitive
94 skync Slovak dictionary order, case-insensitive
95 slvdic Slovenian dictionary order, case-sensitive
96 slvnc Slovenian dictionary order, case-insensitive

1251 Cyrillic

ID Name Description
104 bin_cp1251 Binary order
105 dictionary_1251 Dictionary order, case-sensitive
106 nocase_1251 Dictionary order, case-insensitive
107 ukrdic Ukrainian dictionary order, case-sensitive
108 ukrnc Ukrainian dictionary order, case-insensitive

1253 Greek

ID Name Description
112 bin_cp1253 Binary order
113 dictionary_1253 Dictionary order, case-sensitive
114 nocase_1253 Dictionary order, case-insensitive
120 greek_mixeddictionary Mixed dictionary order
121 greek_altdictionary Dictionary order, case-sensitive, accent-sensitive
124 greek_nocasedict Dictionary order, case-insensitive, accent-insensitive

1254 Turkish

ID Name Description
128 bin_cp1254 Binary order
129 dictionary_1254 Dictionary order, case-sensitive
130 nocase_1254 Dictionary order, case-insensitive

1255 Hebrew

ID Name Description
136 bin_cp1255 Binary order
137 dictionary_1255 Dictionary order, case-sensitive
138 nocase_1255 Dictionary order, case-insensitive

1256 Arabic

ID Name Description
144 bin_cp1256 Binary order
145 dictionary_1256 Dictionary order, case-sensitive
146 nocase_1256 Dictionary order, case-insensitive

1257 Baltic

ID Name Description
152 bin_cp1257 Binary order
153 dictionary_1257 Dictionary order, case-sensitive
154 nocase_1257 Dictionary order, case-insensitive
155 etidic Estonian dictionary order, case-sensitive
156 etinc Estonian dictionary order, case-insensitive
157 lvidic Latvian dictionary order, case-sensitive
158 lvinc Latvian dictionary order, case-insensitive
159 lthdic Lithuanian dictionary order, case-sensitive
160 lthnc Lithuanian dictionary order, case-insensitive

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.