Re: How can I make CASE SENSITIVE UTF8 charset?

[Alexander Barkov]

There are no case sensitive utf8 collations in MySQL yet other than utf8_bin.

The bad side of utf8_bin is that it produces not nice "ORDER BY" results -
capital letters are returned not together with their small counterparts.

If you need just WHERE to work case sensitively,
then you can still use utf8_croatian_ci and do searches like this:

SELECT ... WHERE column='string' and column=binary 'string';

If you need case sensitivity for uniqueness, the you can use utf8_bin
to control uniqueness, and at the same time "nice" ORDER BY,
then try this:

SELECT ... ORDER BY column COLLATE utf8_croatian_ci.