How to JSON_encode resultset from mySQL
I am using Firefox to test a mySQL-stored procedure embedded in a PHP script and using JSON_encode(). In the PHP script, I specified utf8 in the PHP-header.
The stored procedure works fine in mySQL Workbench, it displays the Chinese characters correctly.
In Firefox, everything works until I got some simplified Chinese characters, then the value field returns ???? in Firefox. Values in English are fine.
I think I need some other character set, I cannot think of which.
Can anymore please point in the right direction.
Subject
Written By
Posted
How to JSON_encode resultset from mySQL
August 10, 2018 02:49AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.