iTunes Library

[Peter Haworth]

Thanks Rene, that looks like it covers all the strange characters I'm
seeing.

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 Wed, Apr 9, 2014 at 12:09 AM, René Micout <rene.micout at numericable.com>wrote:

> Hello Peter, I have do that (I think it is not complete) :
>    replace "√®" with "è" in vlListeAlbums
>    replace "√º" with "ü" in vlListeAlbums
>    replace "√©" with "é" in vlListeAlbums
>    replace "√≥" with "ó" in vlListeAlbums
>    replace "≈ì" with "œ" in vlListeAlbums
>    replace "√â" with "É" in vlListeAlbums
>    replace "≈í" with "Œ" in vlListeAlbums
>    replace "√†" with "à" in vlListeAlbums
>    replace "√∂" with "ö" in vlListeAlbums
>    replace "Ãà" with "ä" in vlListeAlbums
>    replace "√∫" with "ú" in vlListeAlbums
>    replace "√∂" with "ú" in vlListeAlbums
>    replace "√™" with "ê" in vlListeAlbums
>    replace "¬∞" with "°" in vlListeAlbums
>    replace "√ã" with "Ë" in vlListeAlbums
>    replace "√´" with "ë" in vlListeAlbums
>    replace "¬∑" with "·" in vlListeAlbums
>    replace "√Æ" with "î" in vlListeAlbums
>    replace "√§" with "ä" in vlListeAlbums
>    replace "√¥" with "ô" in vlListeAlbums
>    replace "√ß" with "ç" in vlListeAlbums
>    replace "√ñ" with "Ö" in vlListeAlbums
>    replace "√Ø" with "ï" in vlListeAlbums
>    replace "√£" with "ã" in vlListeAlbums
>    replace "√Å" with "Á" in vlListeAlbums
> Bon souvenir de Paris
> René
>
> Le 9 avr. 2014 à 01:07, Peter Haworth <pete at lcsql.com> a écrit :
>
> > 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.
> >
> > Assuming that can be done, how do I make sure the artists names and album
> > names are correctly displayed in my fields/option menus/datagrids?  Let's
> > assume for now that I will not be using LC7 for this.
>
> _______________________________________________
> 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
>