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 CE, you require ICU if UCA is used as the NCHAR collation or the CHAR collation because UCA requires ICU. You also require ICU on Windows CE if your CHAR character set does not match your operating system character set.
By default, the ICU library is not installed on Windows CE because they add approximately 1.7 MB to the size of the SQL Anywhere installation on Windows CE. However, you can modify your SQL Anywhere installation at a later date if you require these libraries.
If you do not install the ICU library, you must choose either a collation whose character set matches the Windows CE 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.
Creating databases on the desktop to deploy to Windows CE
When creating a database on the desktop to deploy to a Windows CE device, you must ensure that you only use the UCA collation if the ICU library is installed on the Windows CE device. A database that uses the UCA is unusable on Windows CE if the ICU library is not installed on the device.
For more information about ICU, see Unicode Collation Algorithm (UCA), and Character set conversion.