WordPress 2.5 upgrade: Database encoding serious problems

No idea whether this will help, https://alexking.org/blog/2008/03/06/mysql-latin1-utf8-conversion

Thanks, but I don’t think it does: my database is configured for UTF-8. Here’s a copy of my server settings:

character set client utf8
(Global value) latin1
character set connection utf8
(Global value) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Global value) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_unicode_ci

It seems to me everything is well set for feeding WP with UTF-8. Help!

Solution: comment the DB_CHARSET line in the wp-config.php file. Found in this comment:

I had a similar problem on my blog and all I had to do was to add // to one line in wp-config.php

I changed

define(’DB_CHARSET’, ‘utf8′);

to

// define(’DB_CHARSET’, ‘utf8′);

And everything was fine.

Your link was helpful in the end, thanks very much! Lesson: always check the comments.

phnk –> You’re awesome man! This was also the solution to MY problem ?? I’m from Denmark, and after upgrading to 2.5, all danish characters were substituted with wrong ones. Putting // in front fixed this. I wonder why though?

For those of you using vDeck and have had no problems uploading WordPress 2.5, maybe you can help me. The first time I ftp to my server and tried to open the blog I got this message.”Error establishing a Data Base connection”

Now when I ftp and try to install, I get the message that my wp-config is not right. I have the same data as I did in Webpress 2.3, I logged onto vDeck and checked the files in wordpress, and seen that the files were not uploaded. When using my ftp it shows the files in the Remote site, but somehow they are not reaching my files in vDeck. for the host I put in *******.startlogic.com, I also tried the old way by putting in itsmydeal.net, neither one works.

I also just got through trying // define(’DB_CHARSET’, ‘utf8′);, but didn’t work.

So in summary, do we make changes to the wp-config that I don’t know about. I am at a loss right now.

stlytm –> As far as I know you shouldn’t do anything to wp-config.php. It contains the login-info to the database. If you move the site, then you might have to change this file. I’m not sure though.

I have problem like jokkesvin when I upgrade from 2.0.11 to 2.5

thanks phnk for ur advice, it’s very useful for the other charset/language

@phnk

You da man!

Had the issue when upgrading to 2.5 from 2.3

Thanks.

Massive phew, thank you so much! ?? Just a simple change in config worked (after the upgrade) much to my relief!

I’m experiencing a similar error with special characters just show weird code after an upgrade from 2.3.3 to 2.5.1. I’ve tried commenting out and deleting these 2 lines, which we’re not in my old wp-config:

define('DB_CHARSET', 'utf8'′);
define('DB_COLLATE', '');

But when i take them out i get the following error”

“Warning: Invalid argument supplied for foreach() in /home/content/mywebsite/html/wp-includes/classes.php on line 92”

And all my pages and posts show page not found errors.
I’ve also just tried changing it to:

define('DB_CHARSET', 'UTF-8'′);
and
define('DB_CHARSET', ''′);

But no luck. Any help would be very much appreciated!