utf 8 - How to conduct an Accent Sensitive search in MySql -

I have a MySQL table that includes UFF 8 normal CI collation In the I table, I can see two entries: < / P>

abad
abád

I am using a query that looks like this:

  `word 'with the word SELECT * Where `word` = 'over'  

returns the query both words:

abad
abád

to indicate this One way that I only want to find the word for mysql? I only want a query for the return

abád

I have also tried this query:

  SELECT * FROM 'Words' = 'Abád'  

This gives me no results Thank you for the help.

If your searches on that field are always being pronounced sensitive, then the coating of field is utf8_bin (Which will compare with utf8-encoded bytes for similarity) or use a specific match of a specific language that distinguishes between pronunciation and unused characters.

  col_name varchar (10) collate utf8_bin  

If the search is normally signal-insensitive, but if you want to create an exception for this search Try

  Where col_name = 'abád' colette utf8_bin