On 8/4/06, Cory Nelson <[EMAIL PROTECTED]> wrote:
I recommend using utf-16 in the database - sqlite doesn't fully support utf-8, and some things may give unexpected results if you use it.
Could you give some example of unexpected result with UTF-8? In my experience the only unexpected results with UTF-8 were bugs in my program (like passing non-UTF-8 string). Any other unexpected result should be considered a bug in SQLite and reported as such. Regards, ~Nuno Lucas
-- Cory Nelson http://www.int64.org