Vamos usando este simple SQL Script, copia y pega, editalo con el nombre de las tablas y campos en los que deseas actualizar la información y ejecuta.
UPDATE table_name
SET column_name
= REPLACE(column_name
,’á’,’á’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’ä’,’ä’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’é’,’é’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’í©’,’é’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’ó’,’ó’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’íº’,’ú’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’ú’,’ú’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’ñ’,’ñ’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’í‘’,’Ñ’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’Ã’,’í’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’–’,’–’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’’’,’\”);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’…’,’…’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’–’,’-‘);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’“’,'”‘);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’‒,'”‘);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’‘’,’\”);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’•’,’-‘);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’‡’,’c’);
UPDATE table_name
SET column_name
= REPLACE(column_name
,’Â’,”);