String changed after inserting into db

[harish_dixit1]

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.

[KrisSimonis]

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.