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.mic...@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 <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 > _______________________________________________ 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
