• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: SQLite and Unicode
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: SQLite and Unicode


  • Subject: Re: SQLite and Unicode
  • From: Keary Suska <email@hidden>
  • Date: Tue, 7 Apr 2009 10:14:07 -0600


On Apr 6, 2009, at 2:31 PM, Тимофей Даньшин wrote:

When I insert non-latin strings into my SQLite3 database, they turn into some weird sets of characters (as I select those strings later in Terminal), and the fields, which contain those strings, become unusable by my application.

I googled for it for quite a bit, but everywhere it says that SQLite 3 supports utf8, so there is no advice on what should be done in such situations.

What can I do about it?

Are you properly encoding your C strings with -cStringUsingEncoding:? If so, when you query the column (and properly translate the C string to NSString using -stringWithCString:encoding:), are the characters still mangled?


HTH,

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


References: 
 >SQLite and Unicode (From: Тимофей Даньшин <email@hidden>)

  • Prev by Date: Re: finder file size
  • Next by Date: Re: Invalid strings
  • Previous by thread: SQLite and Unicode
  • Next by thread: Fwd: SQLite and Unicode
  • Index(es):
    • Date
    • Thread