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 that matches the code page of your intended device.

Windows desktop and Windows Mobile

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

• UltraLite utf8_encoding creation parameter
• Overview of character sets, encodings, and collations
• UltraLite connection parameters reference
• Character set considerations
• Securing UltraLite databases