WordPress.org

1. proxi
   Member
   Posted 3 years ago #

   I'm trying to convert my wordpress 1.5.2 site into a 2.0.x site.

   Since I do not want to break anything of what it already working fine, I created a new database. I then uploaded a backup .sql file of the original database.

   In my wp 2.0, I go to wp-admin and I proceed to update the database. However, all my accented letters are now appearing wrong.

   The two tables seem identical, except that the new tables created by the update process are in utf-8 whereas all the other tables are in latin1_swedish...

   What's the deal? How do I get the accents to work right?

   Thaks.!

   brem of http://martinbreton.com

   (new site is at http://martinbreton.com/nouveau-site/ )

2. proxi
   Member
   Posted 3 years ago #

   I forgot to mention that when I publish new articles, the characters appear fine...

3. moshu
   Member
   Posted 3 years ago #

   That's a mysql problem/bug as far as I can remember. If the mysql versions and settings are not the same on the two servers... it always gets borked.

   See if this helps:
   http://wordpress.org/support/topic/55282?replies=10#post-303707

4. proxi
   Member
   Posted 3 years ago #

   It's the same server, just a different database.

5. proxi
   Member
   Posted 3 years ago #

   I guess my question is: is it my backup that is bad or is it when I import it that I do it wrong? Or... :P

6. proxi
   Member
   Posted 3 years ago #

   I also tried inserting the line as it is suggested in the other thread, but it doesn't seem to affect the posts already in the database.

7. proxi
   Member
   Posted 3 years ago #

   I solved my problem by using the database backup plugin. It seems like my phpMyAdmin backup is faulty... w e i r d. weird.

Topic Closed

This topic has been closed to new replies.