Convert db2utf8

Average Rating: 5
Description
*** NOTE ***

This plugin is no longer recommended. Please use "Database Conversion Tool" (https://www.zen-cart.com/downloads.php?do=file&id=2367) instead.

*** NOTE ***


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!!!!
+ Download Latest

Forum Support Thread

Submit An Updated Version


Github Repository
Zen Cart® Versions v1.5.6, v1.5.7
Original Author a_berezin
Last Updated by lat9 - 5 Nov 2021
Downloads 2,022

Version History

Convert db2utf8   -   Version: Convert db2utf8 -
This version, split from the plugin's base GitHub repository, adds the quotes required around text-fields' default values and now makes use of the site's database settings present in the associated /includes/configure.php.   + Download
Zen Cart® Versions v1.5.6, v1.5.7
Date Added 5 Nov 2021
Author lat9
File Size 15.7 KB
PHP 5.3 Safe? No
Downloads 88
 
Convert db2utf8   -   Version: 1.1
Now includes patch utility to fix broken "defaults". Described further in readme.   + Download
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 43
 
Convert db2utf8   -   Version: 1.0 for utf8mb4
Updated to convert to utf8mb4.
Can also be used to fix "mixed collation errors".
  + Download
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 35
 
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.   + 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 2 Jan 2018
Author mc12345678
File Size 9.5 KB
PHP 5.3 Safe? No
Downloads 287
 
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 412
 
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 638
 
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 519
 


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