By jeefers on

I get a ’ instead of ' and - symbols when restoring from a test database. This occured on blog titles but i only have one instance of it after importing. If it wouldnt have been on the front page of the site i wouldnt have noticed it. Its only one blog but its not on the test site and it is on the main site after i do a restore from the test site.

Am i exporting wrong? or restoring wrong?
I just go into phpmyadmin and use everything default and save a mysql dump file then I upload it to the main server and run the mysql command to insert the dump file.

⋅ Categories: Drupal 5.x

Comments

eljustino’s picture

eljustino commented

My guess would be that the two databases are using different types of encoding...

Personal: justinstanley.net
Nerdly: nerdliness.com

varkenshand’s picture

varkenshand commented

It's a character encoding issue, most likely utf8 is not recognized.

I remember having to look in the sql dump, to see what the original character encoding was, Then building a new database with the right encoding before importing.

My problem was that in some stage the encoding was done twice, but I finally resolved it using BigDump.php. Free program that enables manually defining the character set.

good luck, Hans