Specifying the Collation for a Catalog Language
A collation specifies the bit patterns that represent each character and the rules by which characters are sorted and compared. Because Commerce Server 2002 supports multiple languages, you can specify the collation for each language to get better results.
You can specify the collation for a language by using the updatelanguageinfo.vbs script in the Program Files\Microsoft Commerce Server 2002\Support directory.
Add an attribute named collation to the Language element for which you want to specify the collation:
<?xml version = '1.0' encoding='utf-8' ?>
<Languages>
<Language culture_name="ja-JP" display_name="Japanese - Japan" culture_code="0x0411" iso639x="JPN" collation="Japanese_CI_AS" word_breaker=""/>
</Languages>
This will use the Japanese_CI_AS collation for the culture code ja-JP.
Run the following script: UpdatelanguageInfo <path of the languages.xml file>.
SQL Server supports the following collations:
| Sort order ID | SQL collation name |
|---|---|
| 30 | SQL_Latin1_General_Cp437_BIN |
| 31 | SQL_Latin1_General_Cp437_CS_AS |
| 32 | SQL_Latin1_General_Cp437_CI_AS |
| 33 | SQL_Latin1_General_Pref_CP437_CI_AS |
| 34 | SQL_Latin1_General_Cp437_CI_AI |
| 40 | SQL_Latin1_General_Cp850_BIN |
| 41 | SQL_Latin1_General_Cp850_CS_AS |
| 42 | SQL_Latin1_General_Cp850_CI_AS |
| 43 | SQL_Latin1_General_Pref_CP850_CI_AS |
| 44 | SQL_Latin1_General_Cp850_CI_AI |
| 49 | SQL_1Xcompat_CP850_CI_AS |
| 50 | Latin1_General_BIN |
| 51 | SQL_Latin1_General_Cp1_CS_AS |
| 52 | SQL_Latin1_General_Cp1_CI_AS |
| 53 | SQL_Latin1_General_Pref_CP1_CI_AS |
| 54 | SQL_Latin1_General_Cp1_CI_AI |
| 55 | SQL_AltDiction_Cp850_CS_AS |
| 56 | SQL_AltDiction_Pref_CP850_CI_AS |
| 57 | SQL_AltDiction_Cp850_CI_AI |
| 58 | SQL_Scandinavian_Pref_Cp850_CI_AS |
| 59 | SQL_Scandinavian_Cp850_CS_AS |
| 60 | SQL_Scandinavian_Cp850_CI_AS |
| 61 | SQL_AltDiction_Cp850_CI_AS |
| 71 | Latin1_General_CS_AS |
| 72 | Latin1_General_CI_AS |
| 73 | Danish_Norwegian_CS_AS |
| 74 | Finnish_Swedish_CS_AS |
| 75 | Icelandic_CS_AS |
| 80 | Hungarian_BIN (or Albanian_BIN, Czech_BIN, and so on)1 |
| 81 | SQL_Latin1_General_Cp1250_CS_AS |
| 82 | SQL_Latin1_General_Cp1250_CI_AS |
| 83 | SQL_Czech_Cp1250_CS_AS |
| 84 | SQL_Czech_Cp1250_CI_AS |
| 85 | SQL_Hungarian_Cp1250_CS_AS |
| 86 | SQL_Hungarian_Cp1250_CI_AS |
| 87 | SQL_Polish_Cp1250_CS_AS |
| 88 | SQL_Polish_Cp1250_CI_AS |
| 89 | SQL_Romanian_Cp1250_CS_AS |
| 90 | SQL_Romanian_Cp1250_CI_AS |
| 91 | SQL_Croatian_Cp1250_CS_AS |
| 92 | SQL_Croatian_Cp1250_CI_AS |
| 93 | SQL_Slovak_Cp1250_CS_AS |
| 94 | SQL_Slovak_Cp1250_CI_AS |
| 95 | SQL_Slovenian_Cp1250_CS_AS |
| 96 | SQL_Slovenian_Cp1250_CI_AS |
| 104 | Cyrillic_General_BIN (or Ukrainian_BIN, Macedonian_BIN) |
| 105 | SQL_Latin1_General_Cp1251_CS_AS |
| 106 | SQL_Latin1_General_Cp1251_CI_AS |
| 107 | SQL_Ukrainian_Cp1251_CS_AS |
| 108 | SQL_Ukrainian_Cp1251_CI_AS |
| 112 | Greek_BIN |
| 113 | SQL_Latin1_General_Cp1253_CS_AS |
| 114 | SQL_Latin1_General_Cp1253_CI_AS |
| 120 | SQL_MixDiction_Cp1253_CS_AS |
| 121 | SQL_AltDiction_Cp1253_CS_AS |
| 124 | SQL_Latin1_General_Cp1253_CI_AI |
| 128 | Turkish_BIN |
| 129 | SQL_Latin1_General_Cp1254_CS_AS |
| 130 | SQL_Latin1_General_Cp1254_CI_AS |
| 136 | Hebrew_BIN |
| 137 | SQL_Latin1_General_Cp1255_CS_AS |
| 138 | SQL_Latin1_General_Cp1255_CI_AS |
| 144 | Arabic_BIN |
| 145 | SQL_Latin1_General_Cp1256_CS_AS |
| 146 | SQL_Latin1_General_Cp1256_CI_AS |
| 153 | SQL_Latin1_General_Cp1257_CS_AS |
| 154 | SQL_Latin1_General_Cp1257_CI_AS |
| 155 | SQL_Estonian_Cp1257_CS_AS |
| 156 | SQL_Estonian_Cp1257_CI_AS |
| 157 | SQL_Latvian_Cp1257_CS_AS |
| 158 | SQL_Latvian_Cp1257_CI_AS |
| 159 | SQL_Lithuanian_Cp1257_CS_AS |
| 160 | SQL_Lithuanian_Cp1257_CI_AS |
| 183 | SQL_Danish_Pref_Cp1_CI_AS |
| 184 | SQL_SwedishPhone_Pref_Cp1_CI_AS |
| 185 | SQL_SwedishStd_Pref_Cp1_CI_AS |
| 186 | SQL_Icelandic_Pref_Cp1_CI_AS |
| 192 | Japanese_BIN |
| 193 | Japanese_CI_AS |
| 194 | Korean_Wansung_BIN |
| 195 | Korean_Wansung_CI_AS |
| 196 | Chinese_Taiwan_Stroke_BIN |
| 197 | Chinese_Taiwan_Stroke_CI_AS |
| 198 | Chinese_PRC_BIN |
| 199 | Chinese_PRC_CI_AS |
| 200 | Japanese_CS_AS |
| 201 | Korean_Wansung_CS_AS |
| 202 | Chinese_Taiwan_Stroke_CS_AS |
| 203 | Chinese_PRC_CS_AS |
| 204 | Thai_BIN |
| 205 | Thai_CI_AS |
| 206 | Thai_CS_AS |
| 210 | SQL_EBCDIC037_CP1_CS_AS |
| 211 | SQL_EBCDIC273_CP1_CS_AS |
| 212 | SQL_EBCDIC277_CP1_CS_AS |
| 213 | SQL_EBCDIC278_CP1_CS_AS |
| 214 | SQL_EBCDIC280_CP1_CS_AS |
| 215 | SQL_EBCDIC284_CP1_CS_AS |
| 216 | SQL_EBCDIC285_CP1_CS_AS |
| 217 | SQL_EBCDIC297_CP1_CS_AS |
Copyright © 2005 Microsoft Corporation.
All rights reserved.