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

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, 'č','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, 'ł','l'); UPDATE crushed_links SET link = replace( link, 'Ł','L'); 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, 'č','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, 'ł','l'); UPDATE crushed_art SET title = replace( title, 'Ł','L'); 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');