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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite options

UltraLite utf8_encoding creation option

Specify UTF-8 encoding (8-bit multibyte encoding for Unicode) for the database.




1 (databases are 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 of two or more bytes are considered to be alphabetic. You can use these characters in identifiers without requiring double quotes.

Characters in an UltraLite database are either from the codepage implicit in the chosen collation, or are UTF8 encoded. UltraLite databases that use the UTF8BIN collation are automatically UTF8 encoded. If the operating system to which you are deploying your UltraLite application uses UTF8 or Unicode (like most Linux distributions, Microsoft Windows Mobile, and Apple iOS) or if you plan to store characters from multiple languages in your database, you should create your database using a UTF8 encoding. If you try synchronizing UTF-8 encoded characters into a consolidated table that does not support Unicode, a user error is reported.

From SQL Central, you can choose UTF-8 encoding in any wizard that creates a database. On the New database collation and character set page, click the Yes, use UTF-8 as the database character set option.

From a client application, set this option as one of the creation options for the CreateDatabase method on the DatabaseManager/ULDatabaseManager class.