Skip to content

Instantly share code, notes, and snippets.

@salvatorecapolupo

salvatorecapolupo/repair-accentate-wordpress.sql

Last active June 26, 2022 13:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save salvatorecapolupo/3f51523a59ee46e40307663d85131c65 to your computer and use it in GitHub Desktop.
Save salvatorecapolupo/3f51523a59ee46e40307663d85131c65 to your computer and use it in GitHub Desktop.
Download ZIP
Riparazione lettere accentate da DB MySQL. Tratto e ispirato da http://www.suseitalia.org/blog/cicciolinuks/2014/03/27/riparare-lettere-accentate-mysql
Raw
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, "Ú", "Ú");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment