Are you using the 16 bit calls? Like: sqlite3_prepare16_v2 sqlite3_column_text16 sqlite3_open16
That's what I use and I'm able to store and retrieve every non-Latin character I've tried so far. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Harish Dixit > Sent: Friday, April 18, 2008 1:37 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] String is changing after inserting into database > > 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