Bugzilla – Bug 15805
Artists sorting incorrectly on 7.5-embedded SQLite (r30259)
Last modified: 2011-05-25 14:03:16 UTC
As noted in forums thread http://forums.slimdevices.com/showthread.php?t=75730, SQLite appears to be ignoring spaces when sorting artist lists, leading to incorrect ordering. For example, I get the following, with the strings in [square brackets] showing the contents of the ARTISTSORT tag: The Beatles [Beatles, The] Ludwig von Beethoven [Beethoven, Ludwig von] The Be Good Tanyas [Be Good Tanyas, The] Joshua Bell [Bell, Joshua] Leonard Bernstein [Bernstein, Leonard] or this example: Chuck Brown [Brown, Chuck] Jackson Browne [Browne, Jackson] Greg Brown [Brown, Greg] These are ordered correctly in 7.4.2 (ie, The Be Good Tanyas at the top of the first list, and Jackson Browne at the bottom of the second list).
Possibly only an issue on Windows.
(In reply to comment #1) > Possibly only an issue on Windows. I'm seeing in on my server, which is Ubuntu 8.10.
(In reply to comment #1) > Possibly only an issue on Windows. From the thread discussion, it would appear to _not_ be an issue on Windows, only Linux. Sorting works fine for me on my Win2k3 installations.
== Auto-comment from SVN commit #31609 to the slim repo by ayoung == == http://svn.slimdevices.com/slim?view=revision&revision=31609 == bug 16683: Non-ASCII characters in file and directory names Fixed Bug 15805 - Artists sorting incorrectly on 7.5-embedded SQLite Fixed Bug 14800 - Sorting not done correctly with Swedish characters Bug 13153 - Both web interface and squeezebox "hang" when one browses folders containing non-ascii chars Set LC_COLLATE so that SQLite database sorting using perlcollate works for different languages.
Fixed confirmed on build 32464. Closing.