[TYPO3-dev] MySQL First Letter and Umlauts

[Steffen Kamper]

"Steffen Kamper" <steffen at sk-typo3.de> schrieb im Newsbeitrag 
news:mailman.1.1193392777.20453.typo3-dev at lists.netfielders.de...
>
>> I don't have a suggestion, but please check the setup of your newsgroup
>> client. The umlauts in your message did not show up correctly. The 
>> message itself is encoded in ISO-8859-1 while the mail-header seems to 
>> say nothing and thus it was shown in utf-8 in my case. So all your 
>> special chars (umlauts) where '?' before I switched to iso encoding. It's 
>> hard to understand your mails while only seeing question marks in the 
>> critical parts of your message ;)
>>
>> --
>> Greetings,
>> Franz
>
> sry for that, i try same message with utf8 (unfortunally OE does not give 
> me a default setup for charset, i know - M$, but it's easy...):
>
> 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
>
>

damn - i choosed utf8 and after sending it's iso again ... grrrr