Printable View
When you are running the backup of the database into the new blank database via phpMyAdmin make sure to select Latin 1 as the collation.
Your new host is probably using utf8 as the default character set - and that's why Spanish language special characters are becoming corrupted.
utf8 is what everyone will be using eventually, but it's creating havoc with databases that were first compiled in Latin1 or en-iso-8859 (same thing).
Vger
i had originally done utf8 but re imported with latin1 and that fixed my issue.
thanks :)
en-iso-8859 sounds familiar. i think thats what it was set to in my old database.
Ok I found a reference to iso-8859-1 on my spanish.php language file.
// charset for web pages and emails
define('CHARSET', 'iso-8859-1');
Can I change it to latin1?
iso-8859-1 and Latin1 are the same - no need to change anything.
Vger
Just for the benefit of others, the reference above to
by DrByte should probably beQuote:
It will be in the bottom of admin/includes/init_templates.php in the next release.
/admin/includes/init_includes/init_templates.php, as that's where I found it.
CHARSET appears to be set in includes/languages/english.php and /admin/includes/languages/english.php:
Code:// charset for web pages and emails
define('CHARSET', 'iso-8859-1');
I'm having a similar issue. I am migrating hosting companies and upgrading from 1.2.7 to 1.3.6 all at the same time. The shop is primarily English with some Japanese, and I prefer to use UTF for encoding.
i've set the CHARSET define in both admin and catalog areaa to UTF-8. And the pages seem to be loading as such. I've uploaded the DB from the old hosting company to the new in UTF-8. Japanese characters show up in phpmyadmin correctly in new hosting location.
However, I get the customary ????? in both admin and catalog areas.
Stats on new install:
Database: MySQL 5.0.18-standard-log
Server Date: 12/28/2006 11:56:15
Database Date: 12/28/2006 11:56:15
PHP Version: 4.4.4 (Zend: 1.3.0)
HTTP Server: Apache/2.0.54 (Unix) PHP/4.4.2 mod_ssl/2.0.54 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.1.4
I have a short window to do this upgrade and transfer over the new year's holiday, so any help would be appreciated. Thanks in advance!
What's the MySQL and phpMyAdmin Default Character Set?
Vger
Default Char set for MySQL and phpMyAdmin are utf8_unicode_ci.
I've also tried utf8_bin, but that didn't seem to have an effect.
I've entered a new test product on the new server with Japanese and English as a test. The Japanese shows up great in Admin and Catalog views, but is jumbled in phpMyAdmin. So clearly there is a mismatch of encoding somehow.
Am I going to have to re-enter all of the Japanese on my site?
I got this figured out for me. It doesn't make sense, but it works for now.
I saved the old DB and uploaded it to the new servers in Latin1. JPN doesn't display in phpMyAdmin, but works great on the catalog and in the admin. So I'm going with it for now.