Sorting of pieces on composer page

[Boccaccio]

Hi everybody!

I just noticed that the links to the work pages are sorted in a strange way. This phenomenon can be seen best for Christoph Graupner. There is a whole bunch of cantatas by Graupner that start with the word "Ach". In the list, we then first get the cantatas where the second word starts with a capital letter: "Ach Gott...", "Ach Herr...." while cantatas where the second word has a lower case come later on: "Ach bleib..." It would be much more convenient (especially when it comes to check whether all works from the Graupner page have ended up here or not) to have them sorted just by the letter no matter whether is is upper or lower case.

So what we have now is:

Ach Gott...
Ach Herr...
Ach bleib...
Ach stirb...

What would be preferred is:

Ach bleib...
Ach Gott...
Ach Herr...
Ach stirb...

[pml]

The best way to fix these issues would be the {{DEFAULTSORT}} variable - where you can modify the way a page title sorts in all categories simultaneously – but the page processing on IMSLP disables it.

You'll have to re-order in Graupner’s page by adding something like [[Category:Graupner, Christoph|slightly different version of the title to allow it to sort correctly]] to the pages in question.

Cheers PML

[imslp]

First just a note that {{DEFAULTSORT}} usage should probably be kept absolutely minimal, and not to correct systematic problems like this because it takes away all flexibility in the event that, for example, we decide to remove 'Ach' from the sorting process.

That said, the reason for the weird sort is because of the way the database is structured. I think this happens on Wikipedia as well. I know vaguely how to fix it, but this may have to wait for a while because of time constraints.

[Boccaccio]

Well I think there is no need to hurry about this problem, as there as still nearly 1000 works of Graupner to come before we have to think about issues of completeness

[haydenmuhl]

What database does IMSLP use? MySQL?

[imslp]

Yes, I'm trying to find out how to make it sort correctly without having to change the SQL query code. (e.g. just by changing table parameters)

[haydenmuhl]

Not having access to the DB, I can only guess, but it looks like it may be datatype related.

http://dev.mysql.com/doc/refman/5.0/en/ ... ivity.html

"Binary" and "nonbinary" strings are sorted differently. If you don't want to change the datatype of that field, that page lists how to modify the query to do what you want.

I know I've run into this before, but going the opposite direction.

[Emil]

I just spent five minutes looking for Bach's St Matthew Passion.
Unlike most street map indexes, in IMSLP St does not come with the SAs but at the end before Suite.
It's not under Matthaus either.

Could this be improved?

[KGill]

I'm not sure how that could be changed. It does technically make sense the way it is, after all - T comes before U, not with the As. The most practical way to fix it would be to spell out the word 'Saint' in the page title.

[vinteuil]

Actually, I think that "Matthäus-Passion" and "Johannes-Passion" is the best solution, personally

[KGill]

BWV gives 'Matthäuspassion', 'Johannespassion', and 'Lukaspassion' - so that would indeed appear to be the ideal solution.

[Davydov]

Agreed, and done.

[pml]

May I flag “Weinachtsoratorium” for a page move – one for the misspelling of “Weihnachts”, and secondly, the BWV prefers the hyphen and capitalisation of “-Oratorium” rather than having a (typically) long German conglomeration. PML

[vinteuil]

May I flag “Weinachtsoratorium” for a page move – one for the misspelling of “Weihnachts”, and secondly, the BWV prefers the hyphen and capitalisation of “-Oratorium” rather than having a (typically) long German conglomeration. PML

mispelling

[Davydov]

All taken care of (just in time for the 4th cantata)