Riparazione lettere accentate da DB MySQL. Tratto e ispirato da http://www.suseitalia.org/blog/cicciolinuks/2014/03/27/riparare-lettere-accentate-mysql

repair-accentate-wordpress.sql

## ## ## ## ## ## ## ## ## ## ## ## ## ## -
## ## wp_postmeta
## ## ## ## ## ## ## ## ## ## ## ## ## ## -

## minusc
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Ã ", "à");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "è", "è");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ì", "ì");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ò", "ò");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ù", "ù");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "á", "á");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "é", "é");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "í", "í");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ó", "ó");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ú", "ú");
## -maiusc
UPDATE wp_postmeta SET meta_key = replace(meta_key, "À", "À");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "È", "È");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "ÃŒ", "Ì");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Ã’", "Ò");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Ù", "Ù");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Á", "Á");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "É", "É");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Í", "Í");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Ó", "Ó");
UPDATE wp_postmeta SET meta_key = replace(meta_key, "Ú", "Ú");

## minusc
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Ã ", "à");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "è", "è");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ì", "ì");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ò", "ò");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ù", "ù");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "á", "á");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "é", "é");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "í", "í");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ó", "ó");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ú", "ú");
## -maiusc
UPDATE wp_postmeta SET meta_value = replace(meta_value, "À", "À");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "È", "È");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "ÃŒ", "Ì");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Ã’", "Ò");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Ù", "Ù");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Á", "Á");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "É", "É");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Í", "Í");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Ó", "Ó");
UPDATE wp_postmeta SET meta_value = replace(meta_value, "Ú", "Ú");

## ## ## ## ## ## ## ## ## ## ## ## ## ## -
## ## wp_posts
## ## ## ## ## ## ## ## ## ## ## ## ## ## -

## minusc
UPDATE wp_posts SET post_content = replace(post_content, "Ã ", "à");
UPDATE wp_posts SET post_content = replace(post_content, "è", "è");
UPDATE wp_posts SET post_content = replace(post_content, "ì", "ì");
UPDATE wp_posts SET post_content = replace(post_content, "ò", "ò");
UPDATE wp_posts SET post_content = replace(post_content, "ù", "ù");
UPDATE wp_posts SET post_content = replace(post_content, "á", "á");
UPDATE wp_posts SET post_content = replace(post_content, "é", "é");
UPDATE wp_posts SET post_content = replace(post_content, "í", "í");
UPDATE wp_posts SET post_content = replace(post_content, "ó", "ó");
UPDATE wp_posts SET post_content = replace(post_content, "ú", "ú");
## -maiusc
UPDATE wp_posts SET post_content = replace(post_content, "À", "À");
UPDATE wp_posts SET post_content = replace(post_content, "È", "È");
UPDATE wp_posts SET post_content = replace(post_content, "ÃŒ", "Ì");
UPDATE wp_posts SET post_content = replace(post_content, "Ã’", "Ò");
UPDATE wp_posts SET post_content = replace(post_content, "Ù", "Ù");
UPDATE wp_posts SET post_content = replace(post_content, "Á", "Á");
UPDATE wp_posts SET post_content = replace(post_content, "É", "É");
UPDATE wp_posts SET post_content = replace(post_content, "Í", "Í");
UPDATE wp_posts SET post_content = replace(post_content, "Ó", "Ó");
UPDATE wp_posts SET post_content = replace(post_content, "Ú", "Ú");

## minusc
UPDATE wp_posts SET post_title = replace(post_title, "Ã ", "à");
UPDATE wp_posts SET post_title = replace(post_title, "è", "è");
UPDATE wp_posts SET post_title = replace(post_title, "ì", "ì");
UPDATE wp_posts SET post_title = replace(post_title, "ò", "ò");
UPDATE wp_posts SET post_title = replace(post_title, "ù", "ù");
UPDATE wp_posts SET post_title = replace(post_title, "á", "á");
UPDATE wp_posts SET post_title = replace(post_title, "é", "é");
UPDATE wp_posts SET post_title = replace(post_title, "í", "í");
UPDATE wp_posts SET post_title = replace(post_title, "ó", "ó");
UPDATE wp_posts SET post_title = replace(post_title, "ú", "ú");
## -maiusc
UPDATE wp_posts SET post_title = replace(post_title, "À", "À");
UPDATE wp_posts SET post_title = replace(post_title, "È", "È");
UPDATE wp_posts SET post_title = replace(post_title, "ÃŒ", "Ì");
UPDATE wp_posts SET post_title = replace(post_title, "Ã’", "Ò");
UPDATE wp_posts SET post_title = replace(post_title, "Ù", "Ù");
UPDATE wp_posts SET post_title = replace(post_title, "Á", "Á");
UPDATE wp_posts SET post_title = replace(post_title, "É", "É");
UPDATE wp_posts SET post_title = replace(post_title, "Í", "Í");
UPDATE wp_posts SET post_title = replace(post_title, "Ó", "Ó");
UPDATE wp_posts SET post_title = replace(post_title, "Ú", "Ú");

## minusc
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Ã ", "à");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "è", "è");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ì", "ì");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ò", "ò");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ù", "ù");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "á", "á");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "é", "é");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "í", "í");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ó", "ó");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ú", "ú");
## -maiusc
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "À", "À");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "È", "È");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "ÃŒ", "Ì");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Ã’", "Ò");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Ù", "Ù");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Á", "Á");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "É", "É");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Í", "Í");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Ó", "Ó");
UPDATE wp_posts SET post_excerpt = replace(post_excerpt, "Ú", "Ú");