Re: SQLite and Unicode
Re: SQLite and Unicode
- Subject: Re: SQLite and Unicode
- From: Keary Suska <email@hidden>
- Date: Tue, 7 Apr 2009 11:12:45 -0600
On Apr 7, 2009, at 10:39 AM, Тимофей Даньшин wrote:
On Apr 7, 2009, at 8:14 PM, Keary Suska wrote:
Are you properly encoding your C strings with -cStringUsingEncoding:?
Yes, I think so.
At present, I am using the -UTF8String method, but I also tried the -
cStringUsingEncoding: to no avail.
Here is the line that binds the string to the prepared statement:
sqlite3_bind_text(sentence_insert_statement, 1, [string
UTF8String], -1, SQLITE_TRANSIENT);
and I translate it back into NSString by [string
stringWithUTF8String], although I also tried the -stringWithCString:
encoding: method. The characters _are_ mangled.
And the funny thing is that i am able to add non-latin strings to it
by reading sql files from SQLite in Terminal...
How do you define "string" (i.e. how is its value set)? There can be
an issue with UTF8 constant strings. Have you called -
canBeConvertedToEncoding: to make sure "string" is utf-8 compatible?
Best,
Keary Suska
Esoteritech, Inc.
"Demystifying technology for your home or business"
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden