MySQL Forums :: Character Sets, Collation, Unicode :: Unproper order of sorting in utf8. Collation?


Advanced Search

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? 5734 Michal Deks 03/07/2009 08:26AM
Re: Unproper order of sorting in utf8. Collation? 2572 Rick James 03/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.