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

vktechnology
#2

 

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

 

Hi YouNetCo

 

Before

EN = Hello everyone, How are you today ?

TH = สวัสดีทุกคนวันนี้เป็นไงบ้าง
JP = 皆さん、こんにちは。今日はどうですか?
KH =ជំរាបសួរអ្នករាល់គ្នាតើអ្នកនៅថ្ងៃនេះយ៉ាងម៉េចដែរ?
AR =مرحبا بالجميع ، كيف حالك اليوم؟ CH =大家好,你今天好吗?
VN =Xin chào mọi người, hôm nay bạn thế nào?
HINDI =सभी को नमस्कार, आज आप कैसे हैं?

 

When view in mysql database will see like this

After

EN = Hello everyone, How are you today ?

TH = à¸ªà¸§à¸±à¸ªà¸”à¸µà¸—à¸¸à¸à¸„à¸™à¸§à¸±à¸™à¸™à¸µà¹‰à¹€à ¸›à¹‡à¸™à¹„งบ้าง
JP = çš†ã•ã‚“ã€ã“ã‚“ã«ã¡ã¯ã€‚ä»Šæ—¥ã¯ã©ã†ã§ã™ã‹ï ¼Ÿ
KH =ជំរាបសួរអ្នករាល់គ្ áž“áž¶ážáž¾áž¢áŸ’áž“áž€áž“áŸ…ážáŸ’áž„áŸƒáž“áŸáŸ‡áž™á Ÿ‰áž¶áž„ម៉េចដែរ?
AR =مرحبا بالجميع ، كيف حالك اليوم؟
CH =å¤§å®¶å¥½ï¼Œä½ ä»Šå¤©å¥½å—ï¼Ÿ
VN =Xin chà o mọi người, hôm nay bạn thế nà o?
HINDI=सभी को नमस्कार, आज आप कैसे हैं?

 

vktechnology
#3

This should be fixed by default.

If fix it later after site online nearly impossible to solve charectors problem.

vktechnology
#4

After add

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

mysqli_set_charset($hLink,"utf8");

 

--------------------------

Before

EN = Hello everyone, How are you today ?

TH = สวัสดีทุกคนวันนี้เป็นไงบ้าง

JP = 皆さん、こんにちは。今日はどうですか?
KH =ជំរាបសួរអ្នករាល់គ្នាតើអ្នកនៅថ្ងៃនេះយ៉ាងម៉េចដែរ?
AR =مرحبا بالجميع ، كيف حالك اليوم؟ CH =大家好,你今天好吗?
VN =Xin chào mọi người, hôm nay bạn thế nào?
HINDI =सभी को नमस्कार, आज आप कैसे हैं?

 

After

EN = Hello everyone, How are you today ?

TH = สวัสดีทุกคนวันนี้เป็นไงบ้าง

JP = 皆さん、こんにちは。今日はどうですか?
KH =ជំរាបសួរអ្នករាល់គ្នាតើអ្នកនៅថ្ងៃនេះយ៉ាងម៉េចដែរ?
AR =مرحبا بالجميع ، كيف حالك اليوم؟ CH =大家好,你今天好吗?
VN =Xin chào mọi người, hôm nay bạn thế nào?
HINDI =सभी को नमस्कार, आज आप कैसे हैं?