On 5/18/06, Pasquale Imbemba <[EMAIL PROTECTED]> wrote:
What do I need to do to fix this? Must I compile SQLite again having UTF-8 deactivated? I'd prefer using ISO 8859-1 over UTF-8 if possible.
It's probably a bug in the intermediate wrappers (or in you program, off course). Note that you have two layers between your program and the sqlite library (that Java API to access the ODBC driver and the sqlite ODBC driver), so any one of them can be at fault. You can't recompile sqlite to disable UTF-8 (is that possible now?), because if you do then the sqlite ODBC driver will give bad input to the sqlite library (gives UTF-8 strings as input when the library expects ISO-8859-1). A year (probably more) ago I noticed the sqlite ODBC wrapper had bugs when using UTF-8, but I never used it anymore and can be fixed now. Best regards, ~Nuno Lucas
