MySQL Bugs: #63164: achieving case sensitive behavior with utf8_general

Bug #63164	achieving case sensitive behavior with utf8_general_cs
Submitted:	9 Nov 2011 14:39	Modified:	9 Dec 2011 14:44
Reporter:	siri sabbineni	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
I am trying to achieve the case sensitive behavior by assigning the collation as utf8_general_cs but i am getting an error "unknown Collation".
Please let me know if there is a solution to this.

Thanks,
Siri

How to repeat:
while creating the table

Suggested fix:
by assigning the collation utf8_bin,we can achieve the same

Even on 5.5.17 we have only the following collations with cs suffix:

mysql> show collation where `Collation` like '%cs';
+--------------------+---------+----+---------+----------+---------+
| Collation          | Charset | Id | Default | Compiled | Sortlen |
+--------------------+---------+----+---------+----------+---------+
| latin1_general_cs  | latin1  | 49 |         | Yes      |       1 |
| latin2_czech_cs    | latin2  |  2 |         | Yes      |       4 |
| cp1250_czech_cs    | cp1250  | 34 |         | Yes      |       2 |
| latin7_estonian_cs | latin7  | 20 |         |          |       0 |
| latin7_general_cs  | latin7  | 42 |         |          |       0 |
| cp1251_general_cs  | cp1251  | 52 |         |          |       0 |
+--------------------+---------+----+---------+----------+---------+
6 rows in set (0.02 sec)

mysql> select version();
+--------------+
| version()    |
+--------------+
| 5.5.17-debug |
+--------------+
1 row in set (0.00 sec)

Try to use utf8_bin maybe...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".