Query for retrieving all rows containing é

[Ed Weggis]

Hi all,

I am trying to make a query that retrieves all rows containing the character é
It turns out that MySQL does not distinguish between e and é

example:

query

SELECT `products_name`
FROM `CL34190_ZEN_TEST`.`products_description`
WHERE `products_name` LIKE '%pé%'
AND `language_id` =33


1: unité de pédalier BSA 68-124,5mm à 4 pans [piece]
2: Delete pipe, V-brake, adaptable [set à 10]

How do I get only product names with é ???

Thanks,
Ed