Recommended character sets and collations

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

Use the dbinit -le option to obtain a list of all the available character set labels for a SQL Anywhere database. Use the dbinit -l option to obtain a list of available collations for a SQL Anywhere database. See Initialization utility (dbinit).

Where a character set encoding or label must be specified, use the value from the Character set label column or one of the labels listed by dbinit -le. Where a collation must be specified, use the value from the Collation or Alternate collation column or one of the labels listed by dbinit -l.

Note

On Mac OS X, and for languages not found in the tables below, the UTF-8 encoding should be used with collations UCA or UTF8BIN.

 Windows platforms
 Unix platforms