Fix unicode query on PDO

September 18, 2018, 08:15:41 PM

Hi,
I just test PHPRad output project.It have a problem with unicode data utf8.
In project I already check all utf8 setting.It already set,but data still show

?? in table(I use Thai language).
I investigate in your PDO function and find out to solve problem by SET NAME utf8

I add code in file PDODb.php at line 699 to

Code: [Select]

$this->pdo->query("SET NAMES utf8");

It all fix.
Just to tell other utf8 format have a problem.To solve it,You need to add SET NAME too.
Tin.

Re: Fix unicode query on PDO

Reply #1 – December 27, 2018, 11:39:12 PM

Thanks for the update. Added to our roadmap