Hello Everyone,

I am trying to setup a new infrastructure for Apache/PHP/MYSQL, all currently are Windows Server and I am migrating to CentOS in a load balancer enviroment. Everything works however, I am having an annoying problem which I am fighting for few hours now. When I migrate a database over from the Windows server to the Linux Server I am getting bad characters. I have tried character sets and collation on the database but dint help.

below is an example:

it's (On the old server)

It�s (on the new server)

I have tried mysqldump ----default-character-set=latin1 and then imported the the database but I got the following results.

The solution i tried was from this link http://www.orthogonalthought.com/blo...al-characters/

it?s (it changes an apostrophy tp a question mark?)

I am running out of ideas because I have also tried copying raw files from server tp server and still the same issue.

Does anyyone what is cusing this character change, i know that defaults backups are UTF8 and i tried changing them using the --default-character-set switch.

Do i need to change my character set global parameter?

FYI these are joomla websites, if that makes any difference. Any help is greatly appriciated.

Thanks,

Adel

sounds like a codepage problem

I am not sure what codepage means, is this a PHP setting that i can specify?

I fixed the issue by doing a regular mysqldump --database dbname > dbname.sql

and then opened the file and changed utf8 to latin1. that fixes the character issue.

Thanks.

Another option is to use the Unix command dos2unix to remove DOS characters.