On Wed, Apr 9, 2014 at 7:07 AM, Peter Haworth <[email protected]> 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 [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
