Re: utf8 in database but order does not sort correct

[walter]

One additional problem one ecounters with the MySQL sorting when "ä" is treated like "a" is that you have no control over how words are sorted that only differ by the umlaut. For example:

aufdampfen
aufdämpfen
aufdrucken
aufdrücken
aufklaren
aufklären

I would like the words without the umlaut to appear first, but this is a mere coincidence and cannot be controlled, it seems.

Another question is how capitalisation of the words affects the sort order, like here:

komplex
Komplex
kosten
Kosten

Is there any way in which to make sure that the word in lower case is always first? (Any elegant way that is, one without creating a second sorting column or something like that)

Any ideas would be appreciated as building a word-around is rather tiresome. I am using UTF-8 throughout my database.

Thanks!