Contents Index Notes on ANSI collations Using multibyte collations

ASA Database Administration Guide
  International Languages and Character Sets
    Understanding collations

Notes on OEM 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

Contents Index Notes on ANSI collations Using multibyte collations