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
>
>