Convert db2utf8

Average Rating: 5
Description
This PHP script can be used to convert your MySQL database tables from latin1-to-UTF8

Instructions:
0) BACKUP YOUR DATABASE!!!
a) unzip and upload the convert_db2utf8.php file to your store's folder (same folder as nddbc.html file)
b) use your browser to access the file ( http:// your_store_url/convert_db2utf8.php )
c) specify a db-prefix if all the tables start with a common prefix, then click the "Start converting" button at the bottom of the screen.
The conversion will show current progress as it proceeds, and statistics upon completion.
d) DELETE THE convert_db2utf8.php FILE FROM YOUR SERVER when finished.
e) Update your Zen Cart configure.php settings to use 'utf8' for DB_CHARSET and english.php to set CHARSET to 'utf-8'

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

Forum Support Thread

Submit An Updated Version
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Original Author a_berezin
Last Updated by lat9 - 11 Jan 2016
Downloads 1,352

Version History

Convert db2utf8   -   Version: v4
Convert overall database collation, too, if not UTF8.   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 11 Jan 2016
Author lat9
File Size 9.4 KB
PHP 5.3 Safe? Yes
Downloads 319
 
Convert db2utf8   -   Version: v3
Updated to be compatible with PHP >= 5.4   + Download
Zen Cart® Versions v1.3.9, v1.5.0, v1.5.1, v1.5.2, v1.5.3, v1.5.4, v1.5.5
Date Added 28 Jun 2014
Author DrByte
File Size 9.2 KB
PHP 5.3 Safe? Yes
Downloads 573
 
Convert db2utf8   -   Version: 2.0.1 16.10.2007 14:
This Script convert database tables to utf8   + Download
Zen Cart® Versions
Date Added 2 Sep 2011
Author a_berezin
File Size 8.9 KB
PHP 5.3 Safe? Yes
Downloads 460
 


disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR