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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Creating and Configuring UltraLite Databases » Choosing creation-time database properties for UltraLite » UltraLite character considerations

UltraLite character considerations Next Page

UltraLite platform requirements for character set encoding

Each platform has specific character set and encoding requirements.

Palm OS

Never use UTF-8 encoding; Palm does not support Unicode characters. Always choose a collation which matches the code page of your intended device.

Symbian OS

Always use UTF-8 encoding. This is the natural character set of the device. Symbian does not support the MBCS character sets.

Windows desktop and Windows CE

When using a UTF-8 encoded database on Windows, you should pass wide characters to the database. If you use UTF-8 encoding on these platforms, UltraLite expects that non-wide string parameters are UTF-8 encoded, which is not a natural character set to use on Windows. The exception is for connection strings, where string parameters are expected to be in the active code page. However, by using wide characters, you can avoid this complication.

See also