Database showing funny characters

[numenor]

Hi

I've moved an installation of zencart. Both version 1.3.0.1

From
php 4.4.2
Mysql 4.1.18


To
php 4.4.1
Mysql 4.0.25

I had to change some information in the sql file ENGINE=MyISAM DEFAULT CHARSET=latin1 to TYPE=MyISAM

The installation worked but there are some funny characters in my text such as ’
etc.

Is there anyway of getting rid of them without manually doing it by hand.

[DrByte]

If you are able to change your new database's charset or collation settings to latin1, then those characters may convert properly for you. (Talk to your host about what options you have for those settings... you may have to do it table-by-table too.)
Otherwise, manual is likely your only option.

[Vger]

This is getting to be a major problem. Modern versions of MySQL/phpMyAdmin use utf8-en as their default character set. Whilst you can usually specify Latin 1 for uploading files, you generally don't have an option when it comes to downloading files.

The problem, as far as I can see it, is this: utf8-en is what it says "English" (only), while Latin 1 covers all Western European languages and renders non-English characters correctly - including £ and € - which are garbled by UTF8-en, along with any customer name which uses any non-English characters.

Vger