MySQL Bugs: #60843: utf8_unicode_ci can't distinguish some German Accented Characters

Bug #60843	utf8_unicode_ci can't distinguish some German Accented Characters
Submitted:	12 Apr 2011 15:22	Modified:	28 Apr 2011 16:52
Reporter:	Debojyoti Chattopadhya	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Charsets	Severity:	S2 (Serious)
Version:	5.1.50	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
'u' and 'ù' are not determined by COLLATION utf8_unicode_ci.

How to repeat:
Create a table with collation utf8_unicode_ci and field collation also same utf8_unicode_ci

query, then see the problem
select * from <Table> where <Field_Name> = 'u';
+----+------+
| id | word |
+----+------+
|  1 | u    |
|  2 | ù    |
+----+------+

And this problem I encountered for all the accented words like 
a, Å, Á
o, ö 
n, ñ

が, か

etc...

with utf8_unicode_ci collation it's unable to distinguish between these accented characters. So is it a problem with this utf8_unicode_ci collation or can you please help what collation should I use to resolve this ?
In my case I need something like utf8_bin + ci

How to repeat:
How to repeat:
Create a table with collation utf8_unicode_ci and field collation also same utf8_unicode_ci

query, then see the problem
select * from <Table> where <Field_Name> = 'u';
+----+------+
| id | word |
+----+------+
|  1 | u    |
|  2 | ù    |
+----+------+

updating the OS

I would say this is by design, see http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html. It covers some of the examples from this your report.

Thanks Valeriy Kravchuk, but I already gone through that and it's not solved my issue. As I mentioned I need something like 
utf8_bin + ci

Thank you for the feedback.

This problem solved in 5.6 by fix of bug #38758

For instructions how to add a case insensitive, accent sensitive collation to an installed mysql server instance see

http://www.skysql.com/blogs/hartmut/adding-case-insensitive-distinct-unicode-collation

See also https://bugs.mysql.com/bug.php?id=50909

And https://stackoverflow.com/questions/49622470/mssql-to-myssql-migration-collation-equivalen...