Is your database UTF-16 encoded? More information at: http://www.sqlite.org/pragma.html PRAGMA encoding section.
--- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Apr 18, 2008, at 8:37 AM, Harish Dixit 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
