mysql encoding issues

ConsultClifford · 2007-08-08 16:51:19

Hi I have a php mysql site working perfectly on one server i transfered over the site to another server - i changed nothing - and all the foreign characters are messed up - here is what i getNouveau programme Beta lancÃ© pour l'annÃ©e 2006 instead of Nouveau programme Beta lancé pour l'année 2006 tnx sean

08-08-2007 04:51PM

#1
ConsultClifford

Registered Users, Registered Users 2 Posts: 252 ✭✭

Join Date: May 2003

Posts: 140
Hi

I have a php mysql site working perfectly on one server

i transfered over the site to another server - i changed nothing - and all the foreign characters are messed up - here is what i get
Nouveau programme Beta lancÃ© pour l'annÃ©e 2006
instead of
Nouveau programme Beta lancé pour l'année 2006

tnx
sean

0

Comments

#2 08-08-2007 05:23PM

forbairt

Registered Users, Registered Users 2 Posts: 3,594 ✭✭✭

Join Date: September 2004

Posts: 3389

How did you go about transferring the mysql database ? are they both running the same versions ?

0
#3 08-08-2007 05:46PM

seamus

Registered Users, Registered Users 2 Posts: 68,173 ✭✭✭✭

Join Date: July 2001

Posts: 66931

You can check the collation/character set on the tables first off:
show table status from db_name

The "Collation" column will tell you what's being used.

Try resetting the collation on the database;
ALTER DATABASE db_name CHARACTER SET latin1 COLLATE latin1_general_ci;

This sets it to ISO 8859-2 (Western European Standard).

0