Caution when upgrading the version of your WordPress blog to the newest version 2.5! I did this on my blog and he desconfigurou my bank, leaving all accented characters desformatados!
Former: "Connection Limitµthis is, let's hope pros authors VAe worms to rest£to adopt this méall Tamba©m!"
To see the solution I came, click the link below:
Tive that I gerar um script atalizar character by character. Follow as tip:
update `wp_posts` set `post_content` = replace(`post_content`,'The¡','The');
update `wp_posts` set `post_content` = replace(`post_content`,'The¢','â');
update `wp_posts` set `post_content` = replace(`post_content`,'The£','A');
update `wp_posts` set `post_content` = replace(`post_content`,'The©','Is');
update `wp_posts` set `post_content` = replace(`post_content`,'Theª','E');
update `wp_posts` set `post_content` = replace(`post_content`,'The³','Or');
update `wp_posts` set `post_content` = replace(`post_content`,'The´','O');
update `wp_posts` set `post_content` = replace(`post_content`,'Theµ','O');
update `wp_posts` set `post_content` = replace(`post_content`,'The”','O');
update `wp_posts` set `post_content` = replace(`post_content`,'Theº','U');
update `wp_posts` set `post_content` = replace(`post_content`,'The§','C');
update `wp_posts` set `post_content` = replace(`post_content`,'º','º');
update `wp_posts` set `post_content` = replace(`post_content`,'The‰','It');
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`,'A','To');
update `wp_posts` set `post_content` = replace(`post_content`,'In•','O');
update `wp_posts` set `post_content` = replace(`post_content`,'In‡','C');
update `wp_posts` set `post_content` = replace(`post_content`,'σ','A');
update `wp_posts` set `post_content` = replace(`post_content`,'In“','OR');
update `wp_posts` set `post_content` = replace(`post_content`,'Ish','U');
Pingback: BrunoCunha.com » Blog Archive » How to Install Wordpress: tutorial for beginners