09
Oct
06

Character Encoding + Transformation

After the damage has occured, the best way, it seems, to clean this up is to run multiple SQL queries in the phpmyadmin console emulating find/replace on the wp_posts table:

UPDATE wp_posts SET post_content = replace(post_content, “bad”, “good”)

Gestion des accents français

1/ exporter sous MySQL dans le bon encodage (sous wordpress, généralement UTF-8).

2/ encodage correct des accents dans les fichiers :

wp_posts, wp_comments, link_categories etc

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,“à»”,“û”);
update wp_posts set post_title=replace(post_title,“à§”,“ç”);

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,“à»”,“û”);
update wp_posts set post_content=replace(post_content,“à§”,“ç”);

migration : http://codex.wordpress.org/Moving_WordPress (english)

page en français : Migration wordpress un guide pas à pas pour votre migration. (revolunet)

Transition vers WordPress 2.0.4 et transformation d’une base de données iso-8859-15 au format UTF-8 Wireless

Redirection

Redirection par un fichier .htaccess à la racine du blog sur xxx.domaine.fr/wordpress :

RedirectMatch permanent /wordpress/(.*) http://newsite.com/$1

WordPress 2.0 Upgrade Problems: Character Encoding + Transformation

Blogs Imported (categories)


0 Responses to “Character Encoding + Transformation”


  1. No Comments

Leave a Reply




 

October 2006
M T W T F S S
« Sep   Apr »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Recent Comments