ASA Database Administration Guide
International Languages and Character Sets
Understanding collations
Alternate collations are available for compatibility with older versions of Adaptive Server Anywhere, or for special purposes. You can obtain a list of alternate collations by typing the following command at the command prompt:
dbinit -l+
Specifying the -l+
option lists the following collations, in addition to the list of recommended collations:
Collation label | Type | Description |
---|---|---|
437LATIN1 | OEM | Code Page 437, Latin 1, Western |
437ESP | OEM | Code Page 437, Spanish |
437SVE | OEM | Code Page 437, Swedish/Finnish |
819CYR | ANSI | Code Page 819, Cyrillic |
819DAN | ANSI | Code Page 819, Danish |
819ELL | ANSI | Code Page 819, Greek |
819ESP | ANSI | Code Page 819, Spanish |
819ISL | ANSI | Code Page 819, Icelandic |
819LATIN1 | ANSI | Code Page 819, Latin 1, Western |
819LATIN2 | ANSI | Code Page 819, Latin 2, Central/Eastern European |
819NOR | ANSI | Code Page 819, Norwegian |
819RUS | ANSI | Code Page 819, Russian |
819SVE | ANSI | Code Page 819, Swedish/Finnish |
819TRK | ANSI | Code Page 819, Turkish |
850CYR | OEM | Code Page 850, Cyrillic, Western |
850DAN | OEM | Code Page 850, Danish |
850ELL | OEM | Code Page 850, Greek |
850ESP | OEM | Code Page 850, Spanish |
850ISL | OEM | Code Page 850, Icelandic |
850LATIN1 | OEM | Code Page 850, Latin 1, Western |
850LATIN2 | OEM | Code Page 850, Latin 2, Central/Eastern European |
850NOR | OEM | Code Page 850, Norwegian |
850RUS | OEM | Code Page 850, Russian |
850SVE | OEM | Code Page 850, Swedish/Finnish |
850TRK | OEM | Code Page 850, Turkish |
852LATIN2 | OEM | Code Page 852, Latin 2, Central/Eastern European |
852CYR | OEM | Code Page 852, Cyrillic |
852POL | OEM | Code Page 852, Polish |
855CYR | OEM | Code Page 855, Cyrillic |
856HEB | OEM | Code Page 856, Hebrew |
857TRK | OEM | Code Page 857, Turkish |
860LATIN1 | OEM | Code Page 860, Latin 1, Western |
861ISL | OEM | Code Page 861, Icelandic |
862HEB | OEM | Code Page 862, Hebrew |
863LATIN1 | OEM | Code Page 863, Latin 1, Western |
865NOR | OEM | Code Page 865, Norwegian |
866RUS | OEM | Code Page 866, Russian |
869ELL | OEM | Code Page 869, Greek |
920TRK | ANSI | Code Page 920, Turkish, ISO-8859-9 |
1252DEU | ANSI | Code Page 1251, Windows Specialty German, Umlaut chars not equal |