Bugzilla – Bug 5443
Difficult specifying desired sort order (national characters)
Last modified: 2009-07-31 10:14:37 UTC
It is very difficult to make SS display listings (artists, albums, songs etc) sorted in a specific locale. Getting help in in the forums (http://forums.slimdevices.com/showthread.php?t=38189), I was able to make the following manual change to the database: 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; Although this works well, it would of course be unimaginable to ask a user who's not particularly computer-savvy to do this change. SS should include an installation option where one could specify the desired locale to use for sorting, or else an option through the GUI.
Andy suggests that when the user resets their language that it run a database script to reset all these queries to an appropriate sort order.
OK I think this may be fixed in change 14424. When changing the SC language in the web interface, the collations will be changed on the following tables: albums contributors genres tracks Please test with some Swedish data. Note that collations are changed for the following languages: CS -> utf8_czech_ci DA -> utf8_danish_ci SV -> utf8_swedish_ci ES -> utf8_spanish_ci Everyone else gets utf8_general_ci.
This bug has now been fixed in the 7.1 release version of SqueezeCenter! Please download the new version from http://www.slimdevices.com if you haven't already. If you are still experiencing this problem, feel free to reopen the bug with your new comments and we'll have another look.
Reduce number of active targets for SC