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 <p...@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode