Issue
PHP / MySQL web service fails to return JSON encoded data when it contains some non standard ASCII characters. Text in MySQL looks correctly and database has "utf8_unicode_ci" collation.
The issue occurs while running json_encode() function. The web service returns following error:
Type : Error Exception
Message: json_encode(): Invalid UTF-8 sequence in argument
Resolution
Even though the database collation was set to utf8, the PHP "mysli" connection was not using utf8. The issue was resolved by setting the connection encoding with set_charset("utf8");
$this->conn = new mysqli(HOST, USERNAME, PASSWORD, DB);
$this->conn->set_charset("utf8");
PHP 5.4
MySQL 5.5
