LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices

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

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
bathory
Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 10,906

Rep: Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326Reputation: 1326
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

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

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


Reply


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 08:54 PM.

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