Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 07-06-2009, 12:20 PM   #1
Registered: Nov 2005
Distribution: CentOS
Posts: 154

Rep: Reputation: 15
character set problem

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
Old 07-06-2009, 01:14 PM   #2
LQ Guru
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,474

Rep: Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480Reputation: 1480
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.


Last edited by bathory; 07-06-2009 at 01:16 PM.
Old 07-06-2009, 01:33 PM   #3
Registered: Nov 2005
Distribution: CentOS
Posts: 154

Original Poster
Rep: Reputation: 15
Thank you. It looks like a proper post to my issue. I am going to test it now.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Character Set problem Libertes Linux - General 0 09-08-2007 03:27 PM
Korean Character Set bootneck Linux - Newbie 2 06-29-2006 05:41 AM
Character set in the terminal intuxicator Debian 1 05-01-2005 02:56 AM
Character Set displayed problem. chrislee8 Linux - Newbie 3 10-02-2004 12:28 PM
Character Set issues waynediamond Linux - Software 1 07-05-2004 06:26 PM

All times are GMT -5. The time now is 04:32 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration