SQLite, Unicode & LC

[Bob Sneidar]

Just talking out my derrier here, but can’t you simply uniencode all your data that contains odd characters, then store them as a blob in your database? Unidecode them when your read them out of the database?

Bob


On Apr 8, 2014, at 18:58 , Kay C Lan <lan.kc.macmail at gmail.com> wrote:

> On Wed, Apr 9, 2014 at 7:07 AM, Peter Haworth <pete at lcsql.com> wrote:
> 
> I am however, whether I like it or not, having to get into the weird world
>> of Unicode (I think).  Some of the artist names and CD names in my iTunes
>> library have accented characters which end up in the tab delimited file as
>> <not what the original character was>. The corrupted characters then end up
>> in my database.
>> 
>> I don't have any control over how iTunes exports the data so is it possible
>> for me to ensure that what ends up in my sqlite database is correct?  The
>> default text encoding for sqlite db's is UTF-8 but it can be changed to
>> UTF-16, UTF-16le, or UTF-16be.
> 
> 
> I've just done a quick test and inserted my problem name into iTunes
> (appended it to the end of an album name) and I can Export the Playlist and
> it comes back fine. Are you seeing EVERY ascented character corrupted, or
> are some correct?
> 
> As a workaround, with the appropriate playlist selected, select a track,
> then Select All, Copy and Paste into your favourite Text Editor. Does that
> come out correctly?
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode