The sorting is done by MySQL. To get proper sorting you have to modify the MySQL database. Something like this should do the trick for you:
------------------------------------------------------------- #/> mysql -u slimserver -p <enter dbpassword found in /etc/slimserver.prefs> USE slimserver; ALTER TABLE contributors MODIFY namesort text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE contributors MODIFY namesearch text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE albums MODIFY titlesort text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE albums MODIFY titlesearch text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE tracks MODIFY titlesort text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE tracks MODIFY titlesearch text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE genres MODIFY namesort text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE genres MODIFY namesearch text CHARACTER SET latin1 COLLATE latin1_swedish_ci; ------------------------------------------------------------ If you have a database administration tool like phpMyAdmin you can change these settings using that instead. It's a pity we don't get to choose the sort order when we install SlimServer. (It's possible that this actually works out of the box if you have specified a default collation in your MySQL server prior to the SlimServer installation) -- Tuor ------------------------------------------------------------------------ Tuor's Profile: http://forums.slimdevices.com/member.php?userid=13136 View this thread: http://forums.slimdevices.com/showthread.php?t=38189 _______________________________________________ unix mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/unix
