If database table collation are UTF-8 how do I "order by" for german language?
Posted by: Tore Krudtaa
Date: October 24, 2005 07:23AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
If database table collation are UTF-8 how do I "order by" for german language?
3260
October 24, 2005 07:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.