By amitbapat on

MySQL 5.0.18
Apache 2.0.52
PHP 5.0.4
CentOS 4.3

After upgrade Devnagari characters on my site are all garbled.

Here's the screen shot before the upgrade: http://home.comcast.net/~amitbapat/mysite-46.jpg
Here's the screen shot after the upgrade: http://home.comcast.net/~amitbapat/mysite-47.jpg
Here's the update.php result which shows no errors: http://home.comcast.net/~amitbapat/update.php.htm

I'll be happy to provide any more information.

⋅ Categories: Drupal 4.7.x

Comments

amitbapat’s picture

amitbapat commented

If I add new content in Devanagari in the 4.7 site, it works just fine, the only problem is with the content transferred from 4.6.

anner’s picture

anner commented

I'm pretty sure it has to do with these changes: DEFAULT CHARACTER SET utf8 that the update does. I've ceen other folks run into this here on the forums, but don't know if they came up with a better solution, but you should be able to rerun those particular alter table commands to set the default character set to what you want to use. There is probably also a way to override this default setting, but I don't happen to know what it is. Perhaps someone can educate us both?