Convert db2utf8
|
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' 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 |
DrByte - 10 Mar 2021 |
 Downloads |
1,742 |
Version History
| 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?
