accented characters changed [was problems upgrading mysql4 to mysql5]
Posted by: Michel Mouret
Date: June 30, 2010 10:07AM

Hi all.

I am running a french website hosted by a french hoster : OVH

http://www.ossau.net

This site runs Wordpress and a phpBB3.

To upgrade Wordpress to 2.92 I had to upgrade from MySQL4 to MySQL5.
To do this, I exported my database using mysqldumper (I don't really like to type lines of code...).

the sql file exported was coded in latin1.

I had to empty my sql4 db and erase it, then create a new one wich is now version 5. It is the normal procedure at OVH

I imported my database using mysqldumper, all worked ok but...

Almost all accentuated characters have been transformed :'(

Example : Vallée d'Ossau became Vallée d’Ossau

My 6 years old website is dead!!! Can anyone help me assuming that I'm not a professionnal coder?

Thanks.



Edited 3 time(s). Last edit at 07/01/2010 01:12AM by Michel Mouret.

Options: ReplyQuote


Subject
Views
Written By
Posted
accented characters changed [was problems upgrading mysql4 to mysql5]
3134
June 30, 2010 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.