Great! Thanks for the tip, it works very well. I changed it to specifiy utf8 instead of latin-1:
ALTER TABLE contributors MODIFY namesort text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE contributors MODIFY namesearch text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE albums MODIFY titlesort text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE albums MODIFY titlesearch text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE tracks MODIFY titlesort text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE tracks MODIFY titlesearch text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE genres MODIFY namesort text CHARACTER SET utf8 COLLATE utf8_swedish_ci; ALTER TABLE genres MODIFY namesearch text CHARACTER SET utf8 COLLATE utf8_swedish_ci; I will write a bug report / feature request about this. Selling the Squeezebox to my music-interested but not-computer-savvy friends will not be helped by me telling them they need to manually change database tables. -- strindberg ------------------------------------------------------------------------ strindberg's Profile: http://forums.slimdevices.com/member.php?userid=11265 View this thread: http://forums.slimdevices.com/showthread.php?t=38189 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
