If database table collation are UTF-8 how do I "order by" for german language?

[Tore Krudtaa]

Hi.

I see there is possible to user ORDER BY with COLLATE to force the order by to work with other charsets that are table default.

Example1:

Let say database/table charset was Latin1:

SELECT fieldname FROM table ORDER BY fieldname COLLATE collation-name

where collation-name could be e.g.:

latin1_swedish_ci
latin1_german1_ci
latin1_german2_ci

Example2:

Now to the problem:
If I want to use utf8_general_ci for the table and want to sort e.g according to german charset... ??

IF I use utf8_general_ci for table/database and want to sort using german language sorting, how do I do that. I cannot find any collation addressing german.....
I can find utf8_swedish_ci charset under the UTF8 but not any german

How can I do this?



Edited 1 time(s). Last edit at 10/30/2005 06:02AM by Tore Krudtaa.