Zen Cart Database Conversion Tool
This tool is based on v4.1 of convert_db2utf8.php authored by Andrew Berezin and r1.2 of utf8mb4-conversion.php authored by DrByte, essentially combining those two plugins' processing (https://www.zen-cart.com/downloads.php?do=file&id=1318).
This tool can be used to:
1. Convert your database to a utf8 or utf8mb4 character-set while retaining the integrity of non-ASCII characters, e.g. emojis and extended-ASCII like отслеживание дополнительных элементов.
2. Find (and correct) date, datetime and timestamp fields in the database that have invalid '0000-00-00 [00:00:00]' defaults and/or field values. These defaults are no longer supported by strict MySQL servers.
3. Find (and correct) mixed-collation issues in the database, where a table and/or fields in the database have different collations. If a database query compares two fields that have different collations, a MySQL fatal error will result in strict MySQL servers.
|
Forum Support Thread
|
Zen Cart® Versions |
v1.5.6, v1.5.7, v1.5.8
|
Original Author |
lat9 |
Last Updated by |
lat9
- 16 Aug 2023
|
Downloads |
217 |
Version History
Zen Cart Database Conversion Tool - Version: v2.0.1
|
This release contains a BUGFIX (see GitHub issue #8) that enables interoperability with PHP versions 8.0 and later.
|
|
Zen Cart® Versions |
v1.5.6, v1.5.7, v1.5.8
|
Date Added |
16 Aug 2023 |
Author |
lat9 |
File Size |
27.9 KB |
Encapsulated? |
No |
Downloads |
149 |
|
|
|
Zen Cart Database Conversion Tool - Version: v2.0.0
|
|
|
Zen Cart® Versions |
v1.5.6, v1.5.7, v1.5.8
|
Date Added |
14 Mar 2023 |
Author |
lat9 |
File Size |
27.7 KB |
Encapsulated? |
No |
Downloads |
68 |
|
|
|