My experience is that this kind of problem tends towards a he-said, she-said type of thing, and what happens in the end is that everyone is correct from their perspective, but there was some little bit of non-obvious thing that made one party's understanding of the encoding slightly different from the other party's. For whatever reason, UTF encoding seems to suffer badly from Murphy's Law :-). Been there, done that.
I think the best solution would be to post a self-contained replication of the problem, rather than a description of what you're doing. A main() in a .c file would probably be the best way, but it's possible that a shell script (calling sqlite3) or a TCL script (using tclsqlite3) would also be adequate. In my experience, either you'll find that you can't replicate it in a standalone .c file (which is a valuable hint of ... something), or you'll find that other people don't have the same problem (also a valuable hint), or someone will suggest a one-line change which totally fixes it. -scott On Thu, Apr 17, 2008 at 11:37 PM, Harish Dixit <[EMAIL PROTECTED]> wrote: > Hello, > > I am inserting some unicode string into the SQLite database. After > inserting, at the time of retrieving value has been modified. > > For example: > > I am inserting "즒铭ꓽ菷\큭셙냼誜\꾁霤꿩뱪낌.wma" > when i am retrieving it the value is : "铭ꓽ菷\큭셙냼誜\꾁霤꿩뱪낌.wma" > > > It seems that the problem is related to the some symbols having ASCII value > between these ranges: > > 1. 56320 - 57343 > 2. 55296 - 56319 > > > I debugged and found that, upto the point where we call sqlite3_step () > method value goes correctly, but it changed after inserting into the > database. > > > Please help me regarding this issue. > > Thannks in advance. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users