[TYPO3-dev] MySQL First Letter and Umlauts

[Steffen Kamper]

Hi,

i need a tip for an alphabetic List in mySQL (all in utf8).

I did this (for drwiki)
SELECT DISTINCT keyword,ASCII(UPPER(SUBSTRING(keyword,1,1))) letter FROM 
`tx_drwiki_pages` ORDER BY letter

This works fine until the keyword starts with Umlaut, e.g. ÄÖÜ
The strange is that Ä results in ASCII 195, but it is 196 ...

Now i thout to use replace for that chars like REPLACE(keyword,'Ä', 'Ae'), 
but i need more than one replace, i don't know how to do that in one query.

If i change ORDER BY to keyword i get the wrong order (well known in utf8 
with Umlauts)

Any suggestions?

thx, vg
Steffen