Igor Tandetnik wrote >> I can't reproduce this particular problem. Here's the test I wrote: >> Figure out what you are doing differently.
I too did the same using both UTF8 anf UTF16 .Its coming right for UTF8 but its wrong for UTF16. For both encoding I used the below procedure, sqlite3_prepare(db, "insert into t(id, text) values (?, ?)", -1, &insert, 0); unsigned short Name[64]; sqlite3_bind_int(insert, 1, 1); sqlite3_bind_text16(insert, 2, Name, -1, SQLITE_STATIC); sqlite3_step(insert); For UTF8 output is id=2 text=30A2 id=1 text=6B4C This sorting is as expected. For UTF16 output is id=1 text=6B4C id=2 text=30A2 This sorting is not expected. Where I was wrong in UTF16 encoding. Is there any reson for coming in UTF8 and not in UTF16? Thanks & Regards, Mahalakshmi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
