Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » International Languages and Character Sets » Character set and collation reference information

Supported and alternate collations Next Page

Recommended character sets and collations


While SQL Anywhere recognizes the names of hundreds of character sets, code pages, encodings and collations, this section provides listings of those that are recommended for use with Windows and Unix platforms, depending on the language in use.

You can use the dbinit -le option to obtain a list of all of the available character set encodings for a SQL Anywhere database. See Initialization utility (dbinit).

Note

For languages not found in the tables below, the UTF-8 encoding should be used with collations UCA or UTF8BIN.

Windows platforms
LanguageWindows Code PageCharacter set labelCollationAlternate collation
Arabic1256Windows-12561256ARA
Central and Eastern European1250Windows-12501250LATIN2
Danish1252Windows-1252 1252LATIN1
Dutch1252Windows-1252 1252LATIN1
English1252Windows-1252 1252LATIN1
Finnish1252Windows-1252 1252SWEFIN
French1252Windows-1252 1252LATIN1
German1252Windows-1252 1252LATIN1
Greek1253Windows-1253 1253ELL
Hebrew1253Windows-1253 1255HEB
Italian1252Windows-1252 1252LATIN1
Japanese932Windows-31J 932JPN
Korean949IBM949 949KOR
Lithuanian1257Windows-1257 1257LIT
Norwegian1252Windows-1252 1252NOR
Polish1250Windows-1250 1250POL
Portuguese1252Windows-1252 1252LATIN1
Russian1251Windows-1251 1251CYR
Simplified Chinese936GBK 936ZHO
Spanish1252Windows-1252 1252SPA
Swedish1252Windows-1252 1252SWEFIN
Thai874TIS-620 874THAIBIN
Traditional Chinese - Hong Kong 950Big5-HKSCS 950ZHO_HK
Traditional Chinese - Taiwan950Big5 950ZHO_TW
Turkish1254Windows-1254 1254TRK1254TRKALT
Ukrainian1251Windows-1251 1251CYR
Western European 1252Windows-1252 1252LATIN1
Unix platforms
LanguageCharacter set labelCollationAlternate collation
ArabicISO_8859-6:1987 UCA
Central and Eastern EuropeanISO_8859-2:1987 UCA
DanishISO-8859-15 ISO9LATIN1ISO1LATIN1
Dutch ISO-8859-15 ISO9LATIN1ISO1LATIN1
English ISO-8859-15 ISO9LATIN1ISO1LATIN1
Finnish ISO-8859-15 ISO9LATIN1ISO1LATIN1
French ISO-8859-15 ISO9LATIN1ISO1LATIN1
German ISO-8859-15 ISO9LATIN1ISO1LATIN1
GreekISO_8859-7:1987UCA
HebrewISO_8859-8:1988UCA
Italian ISO-8859-15 ISO9LATIN1ISO1LATIN1
Japanese EUC-JP1 EUC_JAPAN
Korean EUC-KR EUC_KOREA
Lithuanian(use UTF-8)UCA or UTF8BIN
Norwegian ISO-8859-15 ISO9LATIN1ISO1LATIN1
PolishISO_8859-2:1987UCA
Portuguese ISO-8859-15 ISO9LATIN1 ISO1LATIN1
RussianISO_8859-5:1988UCA
Simplified Chinese GB2312 EUC_CHINA
Spanish ISO-8859-15 ISO9LATIN1ISO1LATIN1
Swedish ISO-8859-15 ISO9LATIN1ISO1LATIN1
Thai(use UTF-8)UCA or UTF8BIN
Traditional Chinese - Hong KongBig5-HKSCS950ZHO_HK950TWN
Traditional Chinese - TaiwanEUC-TWEUC_TAIWAN
Traditional Chinese - TaiwanBig5 950ZHO_TW
TurkishISO_8859-9:1989920TRK
UkrainianISO_8859-5:1988UCA
Western European ISO-8859-15 ISO9LATIN1ISO1LATIN1

1 EUC-JP is an alternate label for the SQL Anywhere label Extended_UNIX_Code_Packed_Format_for_Japanese.