Reemplaza los caracteres dañados de UTF-8 en MySQL o MariaDB

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 ,’Â’,”);