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

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

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

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