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

[Peter Russ]

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
...

Thanks for your effort.

Regs. Peter.


-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ