WordPress.org

1. phnk
   Member
   Posted 1 month ago #

   There is a serious issue with WP 2.5 RC1 as far as I can tell. My update went perfectly well but all accentuated characters are showing scrambled. Check it here (written in French, hence the high frequency of such chars).

   My first reflex was to blame MySQL, so I went to phpmyadmin and checked my encoding settings:

   - MySQL charset: UTF-8 Unicode (utf8)
   - MySQL connection collation: utf8_unicode_ci

   I then blamed my personal template, but the problem subsists with the Default WP template. Argh!

   What should I change to get my proper character display?

2. GamerZ
   Member
   Posted 1 month ago #

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

3. phnk
   Member
   Posted 1 month ago #

   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!

4. phnk
   Member
   Posted 1 month ago #

   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.

5. jokkesvin
   Member
   Posted 1 month ago #

   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?

6. stlytm
   Member
   Posted 1 month ago #

   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.

7. jokkesvin
   Member
   Posted 1 month ago #

   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.

8. artzja
   Member
   Posted 1 month ago #

   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

9. taoski
   Member
   Posted 1 month ago #

   @phnk

   You da man!

   Had the issue when upgrading to 2.5 from 2.3

   Thanks.

Reply

You must log in to post.