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

SQL Anywhere 11.0.0 » 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.

When using the LOAD TABLE statement, and functions like CSCONVERT, TO_CHAR, and TO_NCHAR, you can refer to the database character set as db_charset, and to the database NCHAR character set as nchar_charset.

For more information about the CHAR and NCHAR data types, see Character data types.