The Unicode Collation Algorithm (UCA) is an algorithm for sorting the entire Unicode character set. It provides linguistically correct comparison, ordering, and case conversion. The UCA was developed as part of the Unicode standard. SQL Anywhere implements the UCA using the International Components for Unicode (ICU) open source library, developed and maintained by IBM.
On Windows Mobile, you require ICU if UCA is used as the NCHAR collation or the CHAR collation. You also require ICU on Windows Mobile if your CHAR character set does not match your operating system character set.
By default, the ICU library is not installed on Windows Mobile because it adds approximately 1.7 MB to the size of the SQL Anywhere installation on Windows Mobile. However, you can modify your SQL Anywhere installation at a later date if you require the ICU library.
If you do not install the ICU library, you must choose either a collation whose character set matches the Windows Mobile character set or the UTF8BIN collation as the CHAR collation when creating your database. Also, you must choose the UTF8BIN collation as the NCHAR collation when creating your database.
When creating a database on the desktop to deploy to a Windows Mobile device, you must ensure that you only use the UCA collation if the ICU library is installed on the Windows Mobile device. A database that uses the UCA is unusable on Windows Mobile if the ICU library is not installed on the device.
For more information about ICU, see Unicode Collation Algorithm (UCA) and Character set conversion.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |