MySQL Forums
Forum List  »  Newbie

How to JSON_encode resultset from mySQL
Posted by: Arthur Chan
Date: August 10, 2018 02:49AM

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.

Options: ReplyQuote

Written By
How to JSON_encode resultset from mySQL
August 10, 2018 02:49AM

Sorry, only registered users may post in this forum.

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.