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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Configuring your database » International languages and character sets » Understanding character sets


Character sets in a SQL Anywhere database

A SQL Anywhere database can use one or two character sets (encodings) for storing character data. The CHAR data types, including CHAR, VARCHAR and LONG VARCHAR, use a single-byte or multibyte character set. UTF-8 may be used. The NCHAR data types, including NCHAR, NVARCHAR, and LONG NVARCHAR, use UTF-8.

SQL statements like LOAD TABLE and functions like CSCONVERT, TO_CHAR, and TO_NCHAR take db_charset and nchar_charset as parameters to refer to the database CHAR character set and to the database NCHAR character set, respectively.

 See also