Most SQL features available in the full version of SQL Anywhere are also available in the Windows CE version. These include transaction processing, referential integrity actions, procedures and triggers, and so on. However, the Java features and the remote data access features are not available on Windows CE.
You should be mindful of the unsupported features when setting database properties on a database intended for a Windows CE device.
For a complete list of unsupported features, see SQL Anywhere feature support on Windows CE.
The following settings are configured during database creation. Once set, these properties can only be changed by rebuilding the database.
Case sensitivity or insensitivity See Case sensitivity.
Treatment of trailing blanks in comparisons By default, databases are created with trailing blanks classified as extra characters. For example, 'Dirk' is not the same as 'Dirk '. You can create databases with blank padding, so that trailing blanks are ignored. See Ignore trailing blanks in comparisons.
Page size See Table and page sizes.
Collation sequence and character set When creating databases for Windows CE, you should use a collation based on the same single- or multibyte character set that Windows would use for the language of interest. For example, if you are using English, French, or German, use the 1252Latin1 collation. If you are using Japanese, use the 932JPN collation, and if you are using Korean, use the 949KOR collation. See Understanding collations.
Do not specify a locale or a sorttype in the tailoring options string when creating a database for use on Windows CE. If you do, it is likely that the will not start on the Windows CE device. For more information about collation tailoring options, see CREATE DATABASE statement.
Using a transaction log on Windows CE
Using jConnect on Windows CE
Using encryption on Windows CE
Creating a Windows CE database
Rebuilding databases on Windows CE
Backing up a Windows CE database
Erasing a Windows CE database