Store Community Support Documentation

If your site using language other than English for example Asian language

Problem when enter some text and open via phpmyadmin will see unreadable chrectors and unable to search.

It hard to maintain your database in the future

 

You need to encode mysql for PHPFOX 4.6 - 4.7.x

1) Go to edit this file

PF.Base/include/library/phpfox/database/driver/mysqli.class.php 

Search for 

$hLink = @mysqli_connect($sHost, $sUser, $sPass, $name, intval($sPort));

Insert this below line above

mysqli_set_charset($hLink,"utf8");

 

***********************

It look like this

$hLink = @mysqli_connect($sHost, $sUser, $sPass, $name, intval($sPort));

mysqli_set_charset($hLink,"utf8");

Last update on June 8, 1:46 pm by vktechnology.
YouNetCo
#1

 

Dear vktechnology,

Thanks for sharing! Can you also provide with two screenshots taken in Database to everyone as before and after you implemented this mysqli_set_charset($hLink,"utf8");?

Kind Regards,

YouNetCo