By ksknagaprasad on

For some reasons I am taking website content backup, after some time I am putting back the same content on to the site, that time I am getting some special characters (Copyright © 2007), why is it so?

⋅ Categories: Drupal 4.7.x

Comments

suit4’s picture

suit4 commented

This is a (not so well known) mysql bug.

I assume, you dump your db via mysql dump and restore it via mysql?

MySQL exports in latin1 by default, the database content creted by drupal is utf8.
For dumping and restoring you need to add the --default-character-set option to your query.

Further information can be found here http://drupal.org/node/76486#comment-141688
or here http://drupal.org/node/187689
or here http://drupal.org/node/198184

xmacinfo’s picture

xmacinfo
he/him
Primary language French
Location Canada
commented

You do have some Unicode issues. Are all your SQL tables using Unicode encoding? Are you backing up from a database set to something else that Unicode to a database set to Unicode? Are you transfering from MySQL 4 to 4.1 (MySQL 4.1 and later can use Unicode encoding for tables)?

You should make sure that all your database tables are set to Unicode. If not, each non-ascii 128 caracters are separated in two.

/*_*/
http://www.xmacinfo.com