Bug 17991 – unnatural sort order

Bug 17991 - unnatural sort order

Summary:

unnatural sort order

Status:	UNCONFIRMED

Product:	Logitech Media Server
Classification:	Unclassified
Component:	Database
Version:	7.7.0
Platform:	PC Ubuntu Linux

Importance:	-- normal (vote)
Target Milestone:	---
Assigned To:	Unassigned bug - please assign me!

URL:
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2012-07-12 09:13 UTC by Christophe Rhodes
Modified:	2012-07-12 09:13 UTC (History)
CC List:	0 users

See Also:
Category:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Christophe Rhodes 2012-07-12 09:13:45 UTC

I have a number of collections of CDs with sequentially-numbered titles, e.g.:

Cantatas, Volume 1 (Bach Collegium Japan)
Cantatas, Volume 2 (Bach Collegium Japan)
...
Cantatas, Volume 10 (Bach Collegium Japan)
Cantatas, Volume 11 (Bach Collegium Japan)
...

In an ideal world, this would also be the order in which they would appear in player listings, or even as database output.  However, they instead display
as

Cantatas, Volume 1 (Bach Collegium Japan)
Cantatas, Volume 10 (Bach Collegium Japan)
Cantatas, Volume 11 (Bach Collegium Japan)
...
Cantatas, Volume 2 (Bach Collegium Japan)
...

It would make me happy if the ordering in this case were the natural one, rather than one from simple character-by-character collation.