Yes. It is UTF-16 encoded On Fri, Apr 18, 2008 at 12:21 PM, Marco Bambini <[EMAIL PROTECTED]> wrote:
> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
