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

[Martin Kutschker]

Peter Russ schrieb:
> Rocco Di Leo schrieb:
> 
>> Hi,
>>
>> there seems to be a problem in the proper data type definition in your
>> table.
>> Use the following two commands on your table and the sorting will work
>> (MySQL 4.1 or greater):
>>
>> ALTER TABLE table_name MODIFY column_name BINARY(255);
>>
>> ALTER TABLE table_name MODIFY column_name VARCHAR(255) CHARACTER SET 
>> utf8;
>>
>> mysql> SELECT * FROM table_name order by column_name;
>>
>> +------------+
>> | column_name   |
>> +------------+
>> | Osterinsel |
>> | Österreich |
>> | Portugal   |
>> +------------+
>> 3 rows in set (0.00 sec)
>>
>> greets
>> Rocco
>>
> 
> Sorry that's not the solution:
> correct sorting would be:
> Oesterreich=Österreich
> Osterinsel

Then you can only switch to latin1_german2_c in your DB or try character 
set casting for the collation of German data.

Masi