Encodes data using the UTF-8 format, 8-bit multibyte encoding for Unicode.
{ ulcreate | ulinit | ulload } -o utf8_encoding=value;...Boolean.
0 (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 of 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. So, 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.
From Sybase Central, you can choose UTF-8 encoding in any wizard that creates a database. On the New database collation and character set page, select the Yes, use UTF-8 as the database character set option.
From a client application, set this parameter as one of the creation parameters for the create database method on the database manager class.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |