MySQL charset converter (beta)
|
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!!!! |
Version History
| MySQL charset converter (beta) - Version: 0.3 | |||||||||||||
| Added fix to handle variable-length char fields | |||||||||||||
|
Report A Problem | ||||||||||||
| MySQL charset converter (beta) - Version: 0.2 | |||||||||||||
| Updated to properly handle fields with NULL and DEFAULT values. | |||||||||||||
|
Report A Problem | ||||||||||||
| MySQL charset converter (beta) - Version: 0.1 | |||||||||||||
|
Report A Problem | ||||||||||||



Zen Cart® Versions
Original Author
Downloads
Date Added
File Size
PHP 5.3 Safe?

