accented/non-accented characters in mySQL's varchar

Does mySQL treat accented and non-accented character as the same. For example "é" is same as "e" ?

From the following simple test it looks like it.

mysql> CREATE TABLE `ct` (`eid` varchar(255) NOT NULL, PRIMARY KEY (`eid`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.13 sec)

mysql> insert into ct values ('décor');
Query OK, 1 row aff开发者_Go百科ected (0.01 sec)

mysql> insert into ct values ('decor');
ERROR 1062 (23000): Duplicate entry 'decor' for key 'PRIMARY'

For my application 'décor' and 'decor' are 2 different values. Can someone help me get around it?

Any help will be useful.

Thanks in advance.

---

It depends on the charset and the collation you have defined for your base and your tables.