Re: Unproper order of sorting in utf8. Collation?
Posted by: Rick James
Date: March 08, 2009 07:13PM

Do
SELECT LENGTH(col), HEX(col) FROM tbl;
I suspect that 'ściana' will say something other than 7. (I got 10.) If so, that is indicative of a double-encoding. You should have done
SET NAMES utf8;

The LENGTH should say 7 and HEX should say C59B6369616E61. If it does, then utf8_polish_ci should be what you want. Probably all other collations will not work correctly for 's' vs 'ś'.

If you have double-encoding, it may be possible to repair the data, but tricky. We can discuss that if necessary.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Unproper order of sorting in utf8. Collation?
2736
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.