Hi Kay, I think I have got this working. Looking at the dictionary entry for uniencode, there's a user note with the following recommendation:
put unidecode(uniencode(tData,"UTF8)) into tData Tried that and it fixed the problem, database looks fine now. The user note credits Devin Assay and Dave Cragg for the solution so thanks to those folks. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Apr 8, 2014 at 6:58 PM, Kay C Lan <lan.kc.macm...@gmail.com> wrote: > On Wed, Apr 9, 2014 at 7:07 AM, Peter Haworth <p...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode