ASA Database Administration Guide
International Languages and Character Sets
Understanding collations
The following table displays the built-in collations that correspond to OEM code pages. The table and the corresponding collations were derived from several manuals from IBM concerning National Language Support, subject to the restrictions mentioned above. (This table represents the best information available at the time of writing.)
Country | Language | Primary Code Page | Primary Collation | Secondary Code Page | Secondary Collation |
---|---|---|---|---|---|
Argentina | Spanish | 850 | 850ESP | 437 | 437ESP |
Australia | English | 437 | 437LATIN1 | 850 | 850LATIN1 |
Austria | German | 850 | 850LATIN1 | 437 | 437LATIN1 |
Belgium | Belgian Dutch | 850 | 850LATIN1 | 437 | 437LATIN1 |
Belgium | Belgian French | 850 | 850LATIN1 | 437 | 437LATIN1 |
Belarus | Belarussian | 855 | 855CYR | ||
Brazil | Portuguese | 850 | 850LATIN1 | 437 | 437LATIN1 |
Bulgaria | Bulgarian | 855 | 855CYR | 850 | 850CYR |
Canada | Cdn French | 850 | 850LATIN1 | 863 | 863LATIN1 |
Canada | English | 437 | 437LATIN1 | 850 | 850LATIN1 |
Croatia | Croatian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Czech Republic | Czech | 852 | 852LATIN2 | 850 | 850LATIN2 |
Denmark | Danish | 850 | 850DAN | ||
Finland | Finnish | 850 | 850SVE | 437 | 437SVE |
France | French | 850 | 850LATIN1 | 437 | 437LATIN1 |
Germany | German | 850 | 850LATIN1 | 437 | 437LATIN1 |
Greece | Greek | 869 | 869ELL | 850 | 850ELL |
Hungary | Hungarian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Iceland | Icelandic | 850 | 850ISL | 861 | 861ISL |
Ireland | English | 850 | 850LATIN1 | 437 | 437LATIN1 |
Israel | Hebrew | 862 | 862HEB | 856 | 856HEB |
Italy | Italian | 850 | 850LATIN1 | 437 | 437LATIN1 |
Mexico | Spanish | 850 | 850ESP | 437 | 437ESP |
Nether-lands | Dutch | 850 | 850LATIN1 | 437 | 437LATIN1 |
New Zealand | English | 437 | 437LATIN1 | 850 | 850LATIN1 |
Norway | Norwegian | 865 | 865NOR | 850 | 850NOR |
Peru | Spanish | 850 | 850ESP | 437 | 437ESP |
Poland | Polish | 852 | 852LATIN2 | 850 | 850LATIN2 |
Portugal | Portuguese | 850 | 850LATIN1 | 860 | 860LATIN1 |
Romania | Romanian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Russia | Russian | 866 | 866RUS | 850 | 850RUS |
S. Africa | Afrikaans | 437 | 437LATIN1 | 850 | 850LATIN1 |
S. Africa | English | 437 | 437LATIN1 | 850 | 850LATIN1 |
Slovak Republic | Slovakian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Slovenia | Slovenian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Spain | Spanish | 850 | 850ESP | 437 | 437ESP |
Sweden | Swedish | 850 | 850SVE | 437 | 437SVE |
Switzerland | French | 850 | 850LATIN1 | 437 | 437LATIN1 |
Switzerland | German | 850 | 850LATIN1 | 437 | 437LATIN1 |
Switzerland | Italian | 850 | 850LATIN1 | 437 | 437LATIN1 |
Turkey | Turkish | 857 | 857TRK | 850 | 850TRK |
UK | English | 850 | 850LATIN1 | 437 | 437LATIN1 |
USA | English | 437 | 437LATIN1 | 850 | 850LATIN1 |
Venezuela | Spanish | 850 | 850ESP | 437 | 437ESP |
Yugoslavia | Macedon-ian | 852 | 852LATIN2 | 850 | 850LATIN2 |
Yugoslavia | Serbian Cyrillic | 855 | 855CYR | 852 | 852CYR |
Yugoslavia | Serbian Latin | 852 | 852LATIN2 | 850 | 850LATIN2 |