[TYPO3-dev] UTF-8 and correct sorting for German umlauts

[Martin Kutschker]

Peter Russ schrieb:
> Martin Kutschker schrieb:
> 
>> Peter Russ schrieb:
>>
>>> Trying to get correct sorted list out of static_countries UTF-8 coded 
>>> for German either delivers Umlaut at the beginning, in between or at 
>>> the end of the list but never at the right place, depending on the 
>>> collate setting utf8_general_ci, utf8_unicode_ci or utf8_bin.
>>
>>
>> What is correct in your opinion?
>>
>> See http://de.wikipedia.org/wiki/Alphabetische_Sortierung for the 
>> options.
>>
>> Masi
> 
> 
> 
> None of this options meets the result you get with Mysql :-(
> I would expect to get Österreich listed at:
> .
> Osterinsel
> Österreich
> Portugal
> .
> 
> but Mysql delivers, depending on collate either
> .
> Afganistan
> Österreich
> Alabanien

odd

> .
> 
> or
> .
> Zululand
> Österreich

good 'ol ASCII

> .
> 
> or
> Österreich
> Äthiopien
> Afganistan

weird

> Any idea?

no

Masi