Hi

I've been at a loss trying to adjust a php script (without knowing anything about php) in order to transform words with letters that have foreign accents to the same letters without the accents. This is in order to query a MySQL database where the records are all without the accents.

Now, I've been told that this is done automatically by MySQL, and all it needs is to make sure that the tables have the utf8 charcater set )which I did not have set) and got an example:


Code:
select _utf8'résumé' COLLATE utf8_general_ci = _utf8'resume'
My problem now is that I don't know what to do with the code. I guess it must supplement this liine in my current code

Code:
$sql = "SELECT Image, Chain, Country, City, Top as '', Medium as '', Low as '' FROM Chains WHERE Country LIKE ? OR City LIKE ?";
Could you help as it is all Chinese to me?

Thank you