Wikipedia:WikiProject Red Link Recovery/Link matching script/Diacritics

From Wikipedia, the free encyclopedia

UPDATE crushed_links SET link = replace( link, 'á','a');
UPDATE crushed_links SET link = replace( link, 'Á','A');
UPDATE crushed_links SET link = replace( link, 'à','a');
UPDATE crushed_links SET link = replace( link, 'À','A');
UPDATE crushed_links SET link = replace( link, 'â','a');
UPDATE crushed_links SET link = replace( link, 'Â','A');
UPDATE crushed_links SET link = replace( link, 'ä','a');
UPDATE crushed_links SET link = replace( link, 'Ä','A');
UPDATE crushed_links SET link = replace( link, 'ã','a');
UPDATE crushed_links SET link = replace( link, 'Ã','A');
UPDATE crushed_links SET link = replace( link, 'å','a');
UPDATE crushed_links SET link = replace( link, 'Å','A');
UPDATE crushed_links SET link = replace( link, 'æ','ae');
UPDATE crushed_links SET link = replace( link, 'Æ','Ae');
UPDATE crushed_links SET link = replace( link, 'ç','c');
UPDATE crushed_links SET link = replace( link, 'Ç','C');
UPDATE crushed_links SET link = replace( link, 'ð','d');
UPDATE crushed_links SET link = replace( link, 'Ð','D');
UPDATE crushed_links SET link = replace( link, 'é','e');
UPDATE crushed_links SET link = replace( link, 'É','E');
UPDATE crushed_links SET link = replace( link, 'è','e');
UPDATE crushed_links SET link = replace( link, 'È','E');
UPDATE crushed_links SET link = replace( link, 'ê','e');
UPDATE crushed_links SET link = replace( link, 'Ê','E');
UPDATE crushed_links SET link = replace( link, 'ë','e');
UPDATE crushed_links SET link = replace( link, 'Ë','E');
UPDATE crushed_links SET link = replace( link, 'í','i');
UPDATE crushed_links SET link = replace( link, 'Í','I');
UPDATE crushed_links SET link = replace( link, 'ì','i');
UPDATE crushed_links SET link = replace( link, 'Ì','I');
UPDATE crushed_links SET link = replace( link, 'î','i');
UPDATE crushed_links SET link = replace( link, 'Î','I');
UPDATE crushed_links SET link = replace( link, 'ï','i');
UPDATE crushed_links SET link = replace( link, 'Ï','I');
UPDATE crushed_links SET link = replace( link, 'ñ','n');
UPDATE crushed_links SET link = replace( link, 'Ñ','N');
UPDATE crushed_links SET link = replace( link, 'ó','o');
UPDATE crushed_links SET link = replace( link, 'Ó','O');
UPDATE crushed_links SET link = replace( link, 'ò','o');
UPDATE crushed_links SET link = replace( link, 'Ò','O');
UPDATE crushed_links SET link = replace( link, 'ô','o');
UPDATE crushed_links SET link = replace( link, 'Ô','O');
UPDATE crushed_links SET link = replace( link, 'ö','o');
UPDATE crushed_links SET link = replace( link, 'Ö','O');
UPDATE crushed_links SET link = replace( link, 'õ','o');
UPDATE crushed_links SET link = replace( link, 'Õ','O');
UPDATE crushed_links SET link = replace( link, 'ø','o');
UPDATE crushed_links SET link = replace( link, 'Ø','O');
UPDATE crushed_links SET link = replace( link, 'œ','oe');
UPDATE crushed_links SET link = replace( link, 'Œ','Oe');
UPDATE crushed_links SET link = replace( link, 'š','s');
UPDATE crushed_links SET link = replace( link, 'Š','S');
UPDATE crushed_links SET link = replace( link, 'ß','ss');
UPDATE crushed_links SET link = replace( link, 'þ','th');
UPDATE crushed_links SET link = replace( link, 'Þ','Th');
UPDATE crushed_links SET link = replace( link, 'ú','u');
UPDATE crushed_links SET link = replace( link, 'Ú','U');
UPDATE crushed_links SET link = replace( link, 'ù','u');
UPDATE crushed_links SET link = replace( link, 'Ù','U');
UPDATE crushed_links SET link = replace( link, 'û','u');
UPDATE crushed_links SET link = replace( link, 'Û','U');
UPDATE crushed_links SET link = replace( link, 'ü','u');
UPDATE crushed_links SET link = replace( link, 'Ü','U');
UPDATE crushed_links SET link = replace( link, 'ý','y');
UPDATE crushed_links SET link = replace( link, 'Ý','Y');
UPDATE crushed_links SET link = replace( link, 'ÿ','y');
UPDATE crushed_links SET link = replace( link, 'ž','z');
UPDATE crushed_links SET link = replace( link, 'Ž','Z');
UPDATE crushed_links SET link = replace( link, 'z.','z');

UPDATE crushed_art SET title = replace( title, 'á','a');
UPDATE crushed_art SET title = replace( title, 'Á','A');
UPDATE crushed_art SET title = replace( title, 'à','a');
UPDATE crushed_art SET title = replace( title, 'À','A');
UPDATE crushed_art SET title = replace( title, 'â','a');
UPDATE crushed_art SET title = replace( title, 'Â','A');
UPDATE crushed_art SET title = replace( title, 'ä','a');
UPDATE crushed_art SET title = replace( title, 'Ä','A');
UPDATE crushed_art SET title = replace( title, 'ã','a');
UPDATE crushed_art SET title = replace( title, 'Ã','A');
UPDATE crushed_art SET title = replace( title, 'å','a');
UPDATE crushed_art SET title = replace( title, 'Å','A');
UPDATE crushed_art SET title = replace( title, 'æ','ae');
UPDATE crushed_art SET title = replace( title, 'Æ','Ae');
UPDATE crushed_art SET title = replace( title, 'ç','c');
UPDATE crushed_art SET title = replace( title, 'Ç','C');
UPDATE crushed_art SET title = replace( title, 'ð','d');
UPDATE crushed_art SET title = replace( title, 'Ð','D');
UPDATE crushed_art SET title = replace( title, 'é','e');
UPDATE crushed_art SET title = replace( title, 'É','E');
UPDATE crushed_art SET title = replace( title, 'è','e');
UPDATE crushed_art SET title = replace( title, 'È','E');
UPDATE crushed_art SET title = replace( title, 'ê','e');
UPDATE crushed_art SET title = replace( title, 'Ê','E');
UPDATE crushed_art SET title = replace( title, 'ë','e');
UPDATE crushed_art SET title = replace( title, 'Ë','E');
UPDATE crushed_art SET title = replace( title, 'í','i');
UPDATE crushed_art SET title = replace( title, 'Í','I');
UPDATE crushed_art SET title = replace( title, 'ì','i');
UPDATE crushed_art SET title = replace( title, 'Ì','I');
UPDATE crushed_art SET title = replace( title, 'î','i');
UPDATE crushed_art SET title = replace( title, 'Î','I');
UPDATE crushed_art SET title = replace( title, 'ï','i');
UPDATE crushed_art SET title = replace( title, 'Ï','I');
UPDATE crushed_art SET title = replace( title, 'ñ','n');
UPDATE crushed_art SET title = replace( title, 'Ñ','N');
UPDATE crushed_art SET title = replace( title, 'ó','o');
UPDATE crushed_art SET title = replace( title, 'Ó','O');
UPDATE crushed_art SET title = replace( title, 'ò','o');
UPDATE crushed_art SET title = replace( title, 'Ò','O');
UPDATE crushed_art SET title = replace( title, 'ô','o');
UPDATE crushed_art SET title = replace( title, 'Ô','O');
UPDATE crushed_art SET title = replace( title, 'ö','o');
UPDATE crushed_art SET title = replace( title, 'Ö','O');
UPDATE crushed_art SET title = replace( title, 'õ','o');
UPDATE crushed_art SET title = replace( title, 'Õ','O');
UPDATE crushed_art SET title = replace( title, 'ø','o');
UPDATE crushed_art SET title = replace( title, 'Ø','O');
UPDATE crushed_art SET title = replace( title, 'œ','oe');
UPDATE crushed_art SET title = replace( title, 'Œ','Oe');
UPDATE crushed_art SET title = replace( title, 'š','s');
UPDATE crushed_art SET title = replace( title, 'Š','S');
UPDATE crushed_art SET title = replace( title, 'ß','ss');
UPDATE crushed_art SET title = replace( title, 'þ','th');
UPDATE crushed_art SET title = replace( title, 'Þ','Th');
UPDATE crushed_art SET title = replace( title, 'ú','u');
UPDATE crushed_art SET title = replace( title, 'Ú','U');
UPDATE crushed_art SET title = replace( title, 'ù','u');
UPDATE crushed_art SET title = replace( title, 'Ù','U');
UPDATE crushed_art SET title = replace( title, 'û','u');
UPDATE crushed_art SET title = replace( title, 'Û','U');
UPDATE crushed_art SET title = replace( title, 'ü','u');
UPDATE crushed_art SET title = replace( title, 'Ü','U');
UPDATE crushed_art SET title = replace( title, 'ý','y');
UPDATE crushed_art SET title = replace( title, 'Ý','Y');
UPDATE crushed_art SET title = replace( title, 'ÿ','y');
UPDATE crushed_art SET title = replace( title, 'ž','z');
UPDATE crushed_art SET title = replace( title, 'Ž','Z');
UPDATE crushed_art SET title = replace( title, 'z.','z');