Skip navigation links

MySQL Forums :: Character Sets, Collation, Unicode :: How can I make CASE SENSITIVE UTF8 charset?


Advanced Search

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
How can I make CASE SENSITIVE UTF8 charset? 30071 hattila 03/22/2005 02:10AM
Re: How can I make CASE SENSITIVE UTF8 charset? 16981 Ron Kass 05/01/2005 10:48AM
Re: How can I make CASE SENSITIVE UTF8 charset? 12141 Alexander Barkov 05/07/2005 07:24AM
Re: How can I make CASE SENSITIVE UTF8 charset? 11402 hattila 06/10/2005 01:15AM
Re: How can I make CASE SENSITIVE UTF8 charset? 13857 mfried 11/03/2005 12:34AM
Re: How can I make CASE SENSITIVE UTF8 charset? 11750 Francois COLOMBIER 03/01/2008 08:59AM
Re: How can I make CASE SENSITIVE UTF8 charset? 13179 Alexander Barkov 03/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.