MySQL Bugs: #36517: Case-sensitive collation for a utf8 column and BINARY

Bug #36517	Case-sensitive collation for a utf8 column and BINARY
Submitted:	5 May 2008 21:00	Modified:	29 Sep 2008 12:41
Reporter:	Victor Porton	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S4 (Feature request)
Version:	5.0.45-community	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
If I want case-sensitive collation for a utf8 column the only option I have is to use utf8_bin (all other utf8_* are case insensitive), but then the column is treated as binary by phpMyAdmin and I have trouble seeing it.

Should resolve either in MySQL or phpMyAdmin, I'm not sure.

How to repeat:
Open phpMyAdmin and add a utf8 column into a table.

Suggested fix:
Add case-sensitive non-binary collation for utf8.

Thank you for the reasonable feature request.

There is worklog task for this already filled at http://forge.mysql.com/worklog/task.php?id=896

Currently you can build mysqld with option  --with-extra-charsets=complex --with-experimental-collations and use collation  utf8_general_cs

That's actually phpMyAdmin bug. utf8_bin is not binary. For binary columns the charset is "binary":

mysql> select charset(1);
+------------+
| charset(1) |
+------------+
| binary     | 
+------------+

Many thanks for writing a bug report. Unfortunately this is not a MySQL bug.
PHPMyAdmin is not a tool from MySQL itself.
Please send your issue to the PHPMyAdmin team. You can find further informations here:
 http://www.phpmyadmin.net/