Re: How can I make CASE SENSITIVE UTF8 charset?
Posted by: Alexander Barkov
Date: March 16, 2008 10:55AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How can I make CASE SENSITIVE UTF8 charset?
19129
March 16, 2008 10:55AM


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.