Each platform has specific character set and encoding requirements.
Never use UTF-8 encoding; Palm does not support Unicode characters. Always choose a collation which matches the code page of your intended device.
Always use UTF-8 encoding. This is the natural character set of the device. Symbian does not support the MBCS character sets.
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.