MySQL Bugs: #61615: Mysql evaluates chars with a comma and chars without a comma as the same

Bug #61615	Mysql evaluates chars with a comma and chars without a comma as the same
Submitted:	23 Jun 2011 17:56	Modified:	23 Jun 2011 18:20
Reporter:	Tomáš Ďuračka	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S2 (Serious)
Version:	5.1.54-1ubuntu4	OS:	Linux (Ubuntu 11.04)
Assigned to:		CPU Architecture:	Any
Tags:	characters, czech, encoding

Description:
There is a huge problem for me with mysql version 5.1.54-1ubuntu4. 

Mysql engine evaluates chars eg. ý,á,í,é  same as chars y,a,i,e. 

This is problem for searching words like ,,modrý" because the result is ,,modrý" but also ,,modry". 

And when i set unique index for some column, words eg. modry and modrý are evaluated as duplicate.

Collation is utf8_czech_ci and encoding is utf8.

Sorry for my english.

How to repeat:
Create column eg. char 5, collation utf8_czech_ci, then insert the word ,,modry" and select column where word = "modrý". The result will be the word modry.

It seems like mysql ignores chars with commas.

Looks like a duplicate of
Bug#32404 Cannot obtain accent sensitive czech collation

Duplicate of Bug #32404.

You're right. My fault. I'm sorry :) But as I can see the topic is three years old and there is still no solution :( I need this to be fixed, it is important feature ...