[TYPO3-dev] MySQL First Letter and Umlauts

[Malte Jansen]

Hi!

I don't if there is Something, you could change the charset in mysql to 
an other utf-charset. A while a go I sortet something with latin_german1 
and latin_german2. Perhaps there is some equal with utf8. I know there 
language-charset. But I don't if there is something for german... So you 
could change the column to this charset.


Malte

Steffen Kamper schrieb:
> 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
> 
>