Collation bug in MySQL 4.1.6 ?
Posted by: Petr Parik
Date: March 13, 2006 05:01PM


I use cp1250 character set and there seems to be an error in how MySQL treats Czech character Ř (R with wedge). Characters as Á (A-stroke) É (E-stroke) Ň (N-wedge) etc. are treated as equal characters to the "base" character A/E/N/etc., whereas Č (C-wedge) Š (S-wedge) Ž (Z-wedge) etc. are treated as distinct characters from base characters C/S/Z/etc. R-wedge belongs to the latter group, however in MySQL it is implemented as the former, which is obviously a mistake (all other characters are implemented correctly).

You can see that because of this queries like "SELECT FROM table WHERE str LIKE 'r%'" can return unwanted rows. Is this corrected in newer versions ?

Petr Parik

Options: ReplyQuote

Written By
Collation bug in MySQL 4.1.6 ?
March 13, 2006 05:01PM

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.