Mr. Bro
Change MySQLi Connection charset
FREE

OC serverID: oc-33993

If You want to find modules, which will be as compatible with the version of the online store, and also pay attention to the quality of the code, then we offer to view: change mysqli connection charset, this solution was specifically designed for stores, working on the platform OpenCart, with the support of our company from every store that works on CMS Brocart.



When you download a free extension, we do not give 100% guarantee that it will work in your store, please be careful about the installation instructions!
With this VQMOD modification the default connection charset utf8 will be changed to utf8mb4 when MySQLi is used. You get that information from your config.php file which database driver is used.

Please note that this is only for the connection between OpenCart and the Database. You have to manually change the character set (collation) of the desired tables to utf8mb4

Important!!!! Before you attempt to upload the xml file please make sure that your MySQL supports utf8mb4 character set!! Test the modification first on a Stage/TEST environment!!!!

Tested for OpenCart 2.3.x and for OpenCart 3.0.2

TAKE A DATABASE BACK UP BEFORE UPLOADING THE VQMOD!!

Константин – 18/07/2017

Приветствую. Спасибо за файл, как раз искал подобное решение для своего магазина, надеюсь что аналогичные потом можно так же будет скачать. Всем рекомендую!