By jeefers on

When upgrading from 5.1 - 5.2 I get an ’ in a couple blog titles. One time the ’ is shown in place of an apostrophe and another time its inplace of a hash. What causes this and is a their a good way to correct this.

⋅ Categories: Drupal 5.x

Comments

alex ua’s picture

alex ua commented

I recently got this problem when I moved a database. It was caused by mistakenly exporting the DB in ascii, rather than utf format. Either way, you can do a replace from within MySQL that will fix the problem. See this article for how to do it:
http://www.nikmakris.com/2005/mar/29.html

Alex UA
Zivtech: Illuminating Technology - Drupal experts in Philadelphia

jeefers’s picture

jeefers commented

Thats a good possiblilty. Whenever i did the upgrade i backed up my main site and restored it on my test site to make sure it was up to date. Then I did the upgrade. With that I only get the symbols on one blog heading. With phpmyadmin i just choose to export it and I dont see anywhere for me to export it to a certain format.
Is there a way to to specify to not change the format that way i can test it to see if the characters still display?

Thanks,

jeff

jeefers’s picture

jeefers commented

Ive got it
you fix this by adding the --default-character-set=utf8 command

so my final restore code looked like this

mysql -u username -p password databasename < databasefile.sql --default-character-set=utf8