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.
Subject
Views
Written By
Posted
6580
March 07, 2009 08:26AM
Re: Unproper order of sorting in utf8. Collation?
2809
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.