Mysql result - "special character" - insensitive

Question

It seems like when I modify the mysql table (in utf-8 table / columns), it is unique in that it returns a repeated input error.

Example:

ALTER TABLE name ADD UNIQUE(name)

Error:

Duplicate entry 'Adé' for key 'name_UNIQUE'

I think this is due to the following lines in my database

Ade, Adé

Can I change a unique table with special characters?

Thank,

Bean

Answer 1

collation ( ), , ) , "e" "é". . , .

, utf8, , , , utf8_bin, , . , , , , . , .

Answer 2

= LIKE LIKE BINARY