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

[Steffen Kamper]

Hi,

I searched a lot about this problem and there seems not to be a solution, 
it's a 'bug' from mysql.
As a workaround i did a string substitution in SQL but this is a weird 
solution - tried with any conversion to latin etc. with no result.

vg  Steffen

"Peter Russ" <peter.russ at 4many.net> schrieb im Newsbeitrag 
news:mailman.1.1156867446.29585.typo3-dev at lists.netfielders.de...
> 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
> .
>
> or
> .
> Zululand
> Österreich
> .
>
> or
> Österreich
> Äthiopien
> Afganistan
> .
>
> Any idea?
>
> Regs. Peter.
>
>
> -- 
> Fiat lux!
> Docendo discimus.
> _____________________________
> 4Many® Services
> openBC: http://www.openbc.com/go/invuid/Peter_Russ