Wayne Venables <[EMAIL PROTECTED]> wrote:Has anyone though of or accomplished converting sqlite so that it handles unicode (wide) characters rather than simply straight ASCII? I would consider this the biggest limitation of sqlite right now; it cannot be adopted anywhere except in countries with the Latin alphabet.
Are you not aware that SQLite supports UTF-8-encoded Unicode? In sqlite.h, #define SQLITE_UTF8 instead of SQLITE_ISO8859.
I wasn't aware! Thank you for pointing that out; I'll have to give that a try.
Unfortunately that still means there is a performance hit converting all data in and out of the library from UTF-8 to UCS16. A large number of operating systems and programming languages store strings natively as UCS16.
Programmer/Analyst WebMotif Net Services, Inc. 1.800.332.WIPS Direct: 604.299.1908 [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
