Hello, my database contains a good 2000 CDs. I've all my Artists (for classical music I use the Artist field for the composer) in the form "Last, First" in the ID tags. Unfortunately they are not properly sorted by the squeezebox server. My OS is OpenSuse 10.3 with LANG set to "en_US.UTF-8".
My guess is that the sorting is messed up due all the European utf8 characters that I'm using, i.e. lots of accented chars, umlaute etc. The support I got from Logitech was not helpful at all. They also believe the problem is caused by the utf8 chars and suggested that I remove all accents, umlaute etc.. Maybe it's simply a problem with the database (I think that's a mySql DB) and I do have to set the correct character set and collation somewhere. Here's is the start of the list of Artists that the squeezebox server displays: --- snip --- a-ha Abyssinians Ace Medtner, Nikolai Karlowitsch Eisler, Hanns Adam, Adolphe Adverts Afrika Bambaataa & The Soulsonic Force Ai Ai Ai Air Airey, Don Kooper, Al Smith, Al Stewart, Al Schönberg, Claude-Michel Couperin, François Alan Parsons Project Morissette, Alanis Alarm Bingen, Hildegard von Albéniz, Isaac Collins, Albert Cropper, Steve, Albert King & Pop Staples Lee, Albert Lortzing, Albert Albinoni, Tomaso Scarlatti, Alessandro Chilton, Alex Guilmant, Felix Alexandre Catalani, Alfredo Alfvén, Hugo Alice Allison, Mose Allman Brothers Alpert, Herb Alpha Blondy Alquin Amazing Blondel Ambassadeurs Internationales Ambros, Wolfgang Vangelis Anastacia Anderson, Laurie Greef, Arthur De Messager, André Grétry, André-Modeste Bloch, Ernest Vollenweider, Andreas Angel Animals Anka, Paul --- snip --- As one can see many of them start with an A, but there are also lots of erroneous ones in the list. BTW the banshee music player sorts them all fine. I'd appreciate any help. Klaus -- ------------------------------- | Klaus Zeitler | | Email: [email protected] | ------------------------------- --- Where there is choice there is misery. _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/unix
