It seems that mysql and php have different thresholds for matching a character with an accent.
Take the spanish name, "Peña."
A query on my database like this: “SELECT * FROM
names WHERE last = ‘Pena’” still turns up Peña, even though the two aren’t exactly the same. (Thank goodness.)
Unfortunately, I can’t do the same in PHP.
$name = ‘Peña’;
$name2 = ‘Pena’;
Try testing $name == $name2 in php, and it will fail.
So my question is this:
Does anyone know of a php script that would replace characters with accents (and other types of carrots and squigglies) with their standard (boring) English counterparts?