PDA

View Full Version : Sort order of albums



bluegaspode
2011-04-18, 16:47
Just had an interesting discussion with someone from Sweden, and learned that when sorting albums, the is treated as an Y in the sort-order.
This is different from Germany, where an will be ordered among the Ue.

Also an in Sweden will be behind the Z, unlike in Germany where it belongs to the A.

Now the SqueezeboxServer seems to do it right (we are talking about 7.5.x right now) - I guess based on the Locale.
Is this done, because the database already uses correct sort order - or do you have any special code in the server that handles these differences in the Locales?

pippin
2011-04-18, 18:18
To turn it around, will show up behind "Z" in Germany...
Looks like the sorting only works correct for accented characters that match your locale.

Mnyb
2011-04-18, 20:35
....Z in Sweden

andyg
2011-04-18, 21:27
This should all be taken care of in 7.6 by the ICU support in SQLite.

On Apr 18, 2011, at 11:35 PM, Mnyb <Mnyb.4sf9pz1303184162 (AT) no-mx (DOT) forums.slimdevices.com> wrote:

>
> ....ZÅÄÖ in Sweden
>
>
> --
> Mnyb
>
> --------------------------------------------------------------------
> Main hifi: Touch + CIA PS +MeridianG68J MeridianHD621 MeridianG98DH 2 x
> MeridianDSP5200 MeridianDSP5200HC 2 xMeridianDSP3100 +Rel Stadium 3
> sub.
> Bedroom/Office: Boom
> Kitchen: SB3 + powered Fostex PM0.4
> Misc use: Radio (with battery)
> iPad 64gB wifi +3g with iPengHD & SqueezePad
> ------------------------------------------------------------------------
> Mnyb's Profile: http://forums.slimdevices.com/member.php?userid=4143
> View this thread: http://forums.slimdevices.com/showthread.php?t=87121
>
>