Why is this PHP call to json_encode silently failing – inability to handle single quotes?

by

You need to set the connection encoding before executing queries. How this is done depends on the API you are using to connect:

  • call mysql_set_charset("utf8") if you use the old, deprecated API.
  • call mysqli_set_charset("utf8") if you use mysqli
  • add the charset parameter to the connection string if you use PDO and PHP >= 5.3.6. In earlier versions you need to execute SET NAMES utf8.

When you obtain data from MySQL any text will be encoded in “client encoding”, which is likely windows-1252 if you don’t configure it otherwise. The character that is causing your problem is the “curly quote”, seen as 92 in the hex dump, which confirms that the mysql client is encoding text in windows-1252.

Another thing you might consider is pass all text through utf8_encode, but in this case it wouldn’t produce the correct result. PHP’s utf8_encode converts iso-8859-1-encoded text. In this encoding \x92 is a non-printable control character, which would be converted into a non-printable control character in utf-8. You could use str_replace("\x92", "'", $input) to fix the problem for this particular character, but if there’s any chance there will be any other non-ascii characters in the database you’ll want to have the client use UTF-8.

More Related Contents:

  1. how to use json_encode for my output?
  2. Extracting data from Json in Php
  3. I keep getting these kind of errors in terms of HttpUrlConnection and BackGroundTask in android
  4. How to convert the json image url string into Bitmap image to display images in android application
  5. Pretty-Printing JSON with PHP
  6. Reference: Why are my “special” Unicode characters encoded weird using json_encode?
  7. Processing large JSON files in PHP
  8. How to use cURL to get jSON data and decode the data?
  9. JSON encode MySQL results
  10. json_encode() escaping forward slashes
  11. PHP Array to JSON Array using json_encode(); [duplicate]
  12. PHP json_encode class private members
  13. How to create a JSON object
  14. How to parse JSON and access results
  15. PHP returning JSON to JQUERY AJAX CALL
  16. Append data to a .JSON file with PHP
  17. Parsing JSON with PHP
  18. handle json request in PHP
  19. How to retrieve Request Payload
  20. PHP decoding and encoding json with unicode characters
  21. Google GCM server returns Unauthorized Error 401
  22. How to generate JSON data with PHP?
  23. How to solve JSON_ERROR_UTF8 error in php json_decode?
  24. How to access JSON decoded array in PHP
  25. Using json_encode on objects in PHP (regardless of scope)
  26. How to loop through PHP object with dynamic keys [duplicate]
  27. Storing arrays in the database
  28. Jquery AJAX post to PHP
  29. Writing JSON object to .json file on server
  30. PHP JSON encode output number as string

Leave a Comment