From Eclipse, I am running a PHP script which has an embedded call to a cloud mySQL stored procedure.
mySQL Workbench can store and display Chinese characters correctly.
Eclipse returns the dataset correctly in English, but Chinese characters cannot be displayed properly.
This is what I 've tried so far:
In mySQL, I created the table with this specification:
ENGINE=INNODB AUTO_INCREMENT= 2468 CHARACTER SET utf8 COLLATE utf8_general_ci;
In the PHP script, I specified the header like this:
header("Content-type:application/json; charset=utf-8");
- The response from executing sproc is json_encoded, like this:
echo json_encode(array("db_response"=>$response));
- And in Eclipse, I've set the preference to UTF-8, like this:
in Window > Preferences: General > Workspace set file encoding to Other UTF-8
Chinese characters are displayed like this: ??????(??)????
Can anyone point me in the right direction, please?
Is there some other fonts I need to download and install in Eclipse? If so, which one?