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)

Advertisements

~ by netlex on October 9, 2006.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: