Puck Roll

Mishmashed Infos that i need, from PHP to the universe and beyond!

Puck Roll - Mishmashed Infos that i need, from PHP to the universe and beyond!

Search and replace French accent in MySQL (with bad encoding)


update entreprises set name = replace(name,'è','è');
update entreprises set name = replace(name,'é','é');
update entreprises set name = replace(name,'û','û');
update entreprises set name = replace(name,'ç','ç');
update entreprises set name = replace(name,'ô','ô');
update entreprises set name = replace(name,'É','É');
update entreprises set name = replace(name,'ë','ë');
update entreprises set name = replace(name,'ï','ï');
update entreprises set name = replace(name,'î','î');
update entreprises set name = replace(name,'ê','ê');
update entreprises set name = replace(name,'à','à');
update entreprises set name = replace(name,'â','â');
update entreprises set name = replace(name,'œ','œ');
update entreprises set name = replace(name,'Î','Î');