SELECT zre_slugname, zra_racename, zra_racedate, zrr_fname, zrr_lname FROM zr_event INNER JOIN zr_race ON zra_event_ID=zre_ID INNER JOIN zr_result ON zrr_race_ID=zra_ID WHERE 'Simard' LIKE :zrr_lname AND zrr_fname LIKE 'Léon' ORDER BY zre_evdate ASC LIMIT 1000

SELECT zrr_fname, zrr_lname FROM zr_result WHERE zrr_lname LIKE 'Simard' AND zrr_fname LIKE 'Léon'

SELECT zrr_fname, zrr_lname FROM zr_result WHERE zrr_lname ='Simard' AND zrr_fname ='Léon'

http://forums.mysql.com/read.php?103,46870,247882
show variables like 'character_set%';


http://stackoverflow.com/questions/1476356/detecting-utf8-broken-characters-in-mysql
SELECT * FROM zr_result WHERE LENGTH(zrr_fname) != CHAR_LENGTH(zrr_fname);


UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'É','É');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'“','"');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'â€','"');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'Ç','Ç');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'Ã','Ã');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'Ã ','À');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ú','ú');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'•','-');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'Ø','Ø');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'õ','õ');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'í','í');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'â','â');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ã','ã');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'á','á');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ó','ó');
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'–','–');

UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'Ã ','à');


UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'é','é'); - 15571 lignes affectées
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'è','è'); - 1664 lignes affectées
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ê','ê'); - 4 lignes
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ë','ë'); - 1638 lignes affectées.
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'î','î'); - 854 lignes affectées
UPDATE `zr_result` set `zrr_fname` = REPLACE(`zrr_fname` ,'ç','ç'); - 3018 lignes


UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'á','á');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'é','é');# 15571 rows affected.
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'í©','é');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'ó','ó');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'íº','ú');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'ú','ú');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'ñ','ñ');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'í‘','Ñ');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'Ã','í');# 7432 rows affected.
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'–','–');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'’','\'');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'…','...');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'–','-');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'“','"');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'â€','"');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'‘','\'');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'•','-');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname`,'‡','c');# MySQL returned an empty result set (i.e. zero rows).
UPDATE `zr_result` SET `zrr_fname` = REPLACE(`zrr_fname` ,'Â','');# 1 row affected.