Unproper order of sorting in utf8. Collation?
Hi I got table with utf8 and Polish words (ęąśćółń accent chars). When I try to sort then using ORDER BY the sorted words are in wrong order(utf8_general_ci). Like:
ala
ściana
dokumenty
When I change collation to utf8_polish_ci order is like that:
ściana
ala
dokumenty
What should I change to make it work like this?
ala
dokumenty
ściana (after 's' char)
Greetings
Majkel
Edited 1 time(s). Last edit at 03/07/2009 08:39AM by Michal Deks.
Subject
Views
Written By
Posted
Unproper order of sorting in utf8. Collation?
6571
March 07, 2009 08:26AM
2803
March 08, 2009 07:13PM
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.