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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite timestamp_increment property Next Page

UltraLite utf8_encoding property

Encodes data using the UTF-8 format, 8-bit multibyte encoding for Unicode.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

-o utf8_encoding=boolean

From Sybase Central    Use any wizard that creates a database.

On the New Database Options page, set the UTF-8 option .

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

All boolean values are supported. For example, true/false, yes/no, 1/0, and so on.


0, or databases are not UTF-8 encoded.


UTF-8 characters are represented by one to four bytes. For other multibyte collations, one or two bytes are used. For all provided multibyte collations, characters comprising two or more bytes are considered to be alphabetic. This means that you can use these characters in identifiers without requiring double quotes.

By encoding your database in UTF-8, UltraLite uses the UTF8BIN collation to sort characters. The UTF8BIN character set is not specific to any particular native language; no specific code page is associated with this character set. Consequently, you can synchronize data from multiple native languages to the same consolidated database. If you try synchronizing UTF-8 encoded characters into a consolidated table that does not support Unicode, a user error is reported.

See also