String changed after inserting into db

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.

Make sure that the language settings are all properly set, this looks like one of them doesn't like the characters the other one is barking at it.