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

Reply via email to