Dear Michael My fix in Mariadb 10 chinese text issue. Just add one line in this file. /etc/my.cnf.d/mysql-clients.cnf [mysql] default-character-set=utf8
BTW: I have some question for PHP+Mariadb bundle. is product behavior or bug? 1. The PHP app must set the server as 127.0.0.1, using locathost is cannot connect. I Using phpmyadmin see the premission table, the server address is 127.0.0.1 2. Create the first MYSQL account is not working, need go to UI Services > MariaDB > MariaDB Permissions and click save. On Fri, Jan 27, 2017 at 4:06 AM, Michael Stauber <mstau...@blueonyx.it> wrote: > Hi Mon Chan. > > > 1. Opencert : how to change mPDO driver? > > You mean OpenCart? In the directory where OpenCart is installed there is > a config.php. In it change this line ... > > define('DB_DRIVER', 'mysqli'); > > ... to this: > > define('DB_DRIVER', 'mpdo'); > > You need to do the same with admin/config.php, too. > > > 2. Can you test OrangeHRM with installer setup? > > I just tried. With the usual php-mysql I get this: > > You need at least MySQL 4.1.x, Detected MySQL ver > > When I replace php-mysql with php-mysqlnd it works and reports this (in > green color): > > MySQL Client OK (ver mysqlnd 5.0.10 - 20111026 - $Id: > e707c415db32080b3752b232487a435ee0372157 $) > MySQL Server OK (ver 5.5.5-10.1.18-MariaDB) > > > 3. For the joomla 1.5 with chinese text (Migrate from 5108R), i need add > > UTF8 support in my.cnf( I forget what set before.) > > I just checked and found this article related and interesting: > > https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/ > > Yes, you can set the character set for databases either on a global > (server) level. Or on a per database level. > > The URL above give some tips on how to do this. > > -- > With best regards > > Michael Stauber > _______________________________________________ > Blueonyx mailing list > Blueonyx@mail.blueonyx.it > http://mail.blueonyx.it/mailman/listinfo/blueonyx >
_______________________________________________ Blueonyx mailing list Blueonyx@mail.blueonyx.it http://mail.blueonyx.it/mailman/listinfo/blueonyx