Re: Query for retrieving all rows containing é

[Ed Weggis]

Hi Peter,

Thanks for stepping in! I am somewhat new to this collation stuff and tinkered around with it without luck.

What I get is this:

Error

SQL query: Documentation

SELECT `products_name`
FROM `CL34190_ZEN_TEST`.`products_description`
WHERE `products_name` LIKE latin1_bin '%é%'
COLLATE utf8_bin
LIMIT 0 , 30;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''%é%' COLLATE utf8_bin
LIMIT 0, 30' at line 1

The only thing I see is that the latin1_bin creates an extra accent which may stuff up the SQL syntax.

I feel I am so close, what is going wrong??