ć and alike
select * from table where flike '%ć%'
gets all the stuff containing 'c'
Is that MySQL or Heidi problem ?
Wikipedia says that ć and c are different letters but MySQL doesn't seem to be aware of that. If the server doesn't get it right, there isn't much you can do from the client.
You try binary comparisons:
SELECT BINARY _utf8'ć'=_utf8'c' AS 'Binary', _utf8'ć' COLLATE utf8_slovenian_ci = _utf8'c' COLLATE utf8_slovenian_ci AS 'Slovenian'; Binary Slovenian 0 1
Of course, you no longer have case insensitive comparisons.
Coz croatian alphabet contains all slovenian characters + extra ć,đ etc
Can you explain what is the diff between cp1250_croatian_ci and latin2_croatian_ci
from upper link ?
Please login to leave a reply, or register at first.