character set problem

vbsaltydog · 07-06-2009, 12:20 PM

I recently moved some sites over from a centos box to a rackspace cloud server and used mysqldump to dump the databases on the first server and restored the dump files on the new server but somewhere along the line, the characters got messed up on the new server where double quotes are being displayed as ï¿½ï¿ on the website.
I am certain this is a character set mismatch issue but I dont know if it is the character set on mysql itself, or the db itself, or the linux build itself, or what.

Please advise.

Thank you

bathory · 07-06-2009, 01:14 PM

By default mysqldump uses utf8, so I guess your new mysql server uses a different charset/collation. The usual thing to do is to use iconv with the dump file. Take a look at this post for details.

Regards

vbsaltydog · 07-06-2009, 01:33 PM

Thank you. It looks like a proper post to my issue. I am going to test it now.