Unproper order of sorting in utf8. Collation?
Posted by: Michal Deks
Date: March 07, 2009 08:26AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Unproper order of sorting in utf8. Collation?
6571
March 07, 2009 08:26AM


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.