ć and alike

select * from table where f like '%ć%' and not like '%c%'

gets nothing

select * from table where flike '%ć%'

gets all the stuff containing 'c'

Is that MySQL or Heidi problem ?

That's a problem with the collation of the column. Which collation is it?

utf8_slovenian_ci

looks strange that colation is problem, heidi shows sample content in that col right: 'Morski konjić'

Collation has absolutely nothing to do with display. Collation is the set of rules you use to compare characters and decide whether they're equal or which comes first when sorting.

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.

so, I should use cp1250_croatian_ci ? https://dev.mysql.com/doc/refman/5.1/en/charset-ce-sets.html

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 ?

I can't see the gain: as per the chart MySQL's cp1250_croatian_ci implementation considers ć and c different letters as well.