Convert db2utf8
|
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!!!! |
 Zen Cart® Versions |
v1.5.6, v1.5.7 |
 Original Author |
a_berezin |
| Last Updated by |
lat9 - 5 Nov 2021 |
 Downloads |
1,859 |
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. | |||||||||||
|
|||||||||||
| Convert db2utf8 - Version: 1.1 | |||||||||||
| Now includes patch utility to fix broken "defaults". Described further in readme. | |||||||||||
|
|||||||||||
| Convert db2utf8 - Version: 1.0 for utf8mb4 | |||||||||||
|
Updated to convert to utf8mb4. Can also be used to fix "mixed collation errors". |
|||||||||||
|
|||||||||||
| 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. | |||||||||||
|
|||||||||||
| Convert db2utf8 - Version: v4 | |||||||||||
| Convert overall database collation, too, if not UTF8. | |||||||||||
|
|||||||||||
| Convert db2utf8 - Version: v3 | |||||||||||
| Updated to be compatible with PHP >= 5.4 | |||||||||||
|
|||||||||||
| Convert db2utf8 - Version: 2.0.1 16.10.2007 14: | |||||||||||
| This Script convert database tables to utf8 | |||||||||||
|
|||||||||||
Date Added
File Size
PHP 5.3 Safe?
