Convert db2utf8

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

Instructions (also contained in the README in more detail):
0) BACKUP YOUR DATABASE!!!
a) unzip and upload the utf8mb4-conversion.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/utf8mb4-conversion.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 utf8mb4-conversion.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'

ALERT: The latest version of this script can be found by clicking the Github Repository link next to this description.

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!!!!

Forum Support Thread

Zen Cart® Versions v1.5.6, v1.5.7
Original Author a_berezin
Last Updated by DrByte - 28 May 2021
Downloads 1,776

Version History

Convert db2utf8   -   Version: 1.1
Now includes patch utility to fix broken "defaults". Described further in readme.  
Zen Cart® Versions v1.5.6, v1.5.7
Date Added 28 May 2021
Author DrByte
File Size 15.4 KB
PHP 5.3 Safe? No
Downloads 22
 
Convert db2utf8   -   Version: 1.0 for utf8mb4
Updated to convert to utf8mb4.
Can also be used to fix "mixed collation errors".
 
Zen Cart® Versions v1.5.6, v1.5.7
Date Added 10 Mar 2021
Author DrByte
File Size 12.5 KB
PHP 5.3 Safe? No
Downloads 17
 
Convert db2utf8   -   Version: v4.1
Updated to fully support converting the overall database collation to include databases that require management by quoted identifiers when using the tool to convert the database.  
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 2 Jan 2018
Author mc12345678
File Size 9.5 KB
PHP 5.3 Safe? No
Downloads 252
 
Convert db2utf8   -   Version: v4
Convert overall database collation, too, if not UTF8.  
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 390
 
Convert db2utf8   -   Version: v3
Updated to be compatible with PHP >= 5.4  
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 603
 
Convert db2utf8   -   Version: 2.0.1 16.10.2007 14:
This Script convert database tables to utf8  
Zen Cart® Versions
Date Added 2 Sep 2011
Author a_berezin
File Size 8.9 KB
PHP 5.3 Safe? Yes
Downloads 492
 


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