MySQL 4.0 to 4.1 Encoding Problem
|
|
|
Question / Problem
|
When upgrading or moving a database dump from MySQL 4.0 to 4.1, Unicode data stored by Drupal becomes gibberish
|
Solution
|
|
To use the module, install and enable it, then navigate to update.php, and select update 1 for the module, then initiate the update process. You may disable the module when done.
If you can't log in to your site after the upgrade and as a result can't enable the module (happened to me), then run the following MySQL query through MySQL's command-line client or an interface such as phpMyAdmin:
INSERT INTO system
VALUES('modules/utf8upgrade/utf8upgrade.module',
'utf8upgrade', 'module', '', 1, 0, 0, 0, 0);
A couple of warnings: if your database contains tables that belong to a web application other than Drupal, the module may have side effects on this application as it iterates over all tables. You may need to modify the iteration logic and limit it to Drupal tables.
if you want to use the module, please backup your database first
|
Applies to |
|
My Sql
|
Rank It |
|
