iTunes Library

[René Micout]

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.