If database table collation are UTF-8 how do I "order by" for german language?
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.
Subject
Views
Written By
Posted
If database table collation are UTF-8 how do I "order by" for german language?
3353
October 24, 2005 07:23AM
1940
October 25, 2005 05:18AM
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.