MySQL charset converter (beta)

Description
This PHP script can be used to convert your MySQL database tables from latin1-to-UTF8 while retaining the integrity of all internal multibyte characters.

Instructions:
0) BACKUP YOUR DATABASE!!!
a) unzip and upload the PHP file to your store's folder
b) edit the PHP file to set your database username, password, dbname, and prefix
c) use your browser to access the file
The conversion will show current progress as it proceeds, and statistics upon completion.
d) DELETE THE FILE FROM YOUR SERVER when finished.
e) Update your Zen Cart configure.php settings to use UTF8 for DB_CHARSET

CAUTION: If your database is NOT in UTF8 format but contains UTF8 characters, you may end up with unpredictable results. ALWAYS MAKE A DATABASE BACKUP FIRST!!!!
+ Download Latest

Submit An Updated Version
Zen Cart® Versions
Original Author DrByte
Last Updated by DrByte - 2 Jul 2011
Downloads 1,006

Version History

MySQL charset converter (beta)   -   Version: 0.3
Added fix to handle variable-length char fields   + Download
Zen Cart® Versions
Date Added 2 Jul 2011
Author DrByte
File Size 4.7 KB
PHP 5.3 Safe? Yes
Downloads 893
Report A Problem
 
MySQL charset converter (beta)   -   Version: 0.2
Updated to properly handle fields with NULL and DEFAULT values.   + Download
Zen Cart® Versions
Date Added 1 Jul 2011
Author DrByte
File Size 4.1 KB
PHP 5.3 Safe? Yes
Downloads 23
Report A Problem
 
MySQL charset converter (beta)   -   Version: 0.1
  + Download
Zen Cart® Versions
Date Added 3 Jun 2011
Author DrByte
File Size 2.9 KB
PHP 5.3 Safe? Yes
Downloads 90
Report A Problem