PHP PDO - Json encode with UTF-8

Question

I have this data to datatable cell: AlgoVital Plus čćš so some characters is utf-8

Here's my database schema

enter image description here

After that I make json file with php and send it to fronted:

//header
header('Content-Type: text/html; charset=utf-8');
...
...
//at the end of php file:
 $jsonTable = json_encode($table);
    //echo $jsonTable;
    } catch(PDOException $e) {
        echo 'ERROR: ' . $e->getMessage();
    }
    echo $jsonTable;

and HTML head is OK too:

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta charset="utf-8">

but I cant show data with utf-8 characters... WHy?

JSON is not format with utf-8 characers... etc. where I have some characters like čćšž then I just get NULL at JSON file, when I use json encode

How I can solve this?

possible duplicate of [json\_encode is returning NULL?](http://stackoverflow.com/questions/1972006/json-encode-is-returning-null) — Mike, Mar 02 '15 at 18:22
Why would you send text/html content type header when the content is application/json? — Mike Brant, Mar 02 '15 at 18:39
@johnymile Now show some proof that the data was properly entered as UTF-8, a screenshot of the data in the DB. — Ruan Mendes, Mar 02 '15 at 18:42
I am with @JuanMendes here in that show have not shown enough context/debugging info to determine if the problem is DB-related or JSON encoding related. PHP's json_encode assumes a UTF-8 character set, so typically there shuold not be a problem encoding UTF-8 characters to their JSON escape sequences. — Mike Brant, Mar 02 '15 at 18:45
http://i.imgur.com/Vkb0R6O.png - please see last enter record, there is utf-8 characters — johny mile, Mar 02 '15 at 18:45
OK. So your collations look OK, but what is the character set of the table? Can you past your `SHOW CREATE TABLE` information? Also, assuming this everything is correct with database set up, have you demonstrated that you can output these characters directly in response without JSON-encoding? In other words, what led you to believe that the problem lies in the JSON-encoding step? — Mike Brant, Mar 02 '15 at 18:51
the problem was been with data, when I add it manualz then wont work, but when data comes from ajax when I add data, then works fine, THANKS VERZ MUCH FOR HELP — johny mile, Mar 02 '15 at 21:05

score 1 · Answer 1 · answered Mar 02 '15 at 18:37

1

Try this

$table = '[{name: "PHP",version: 5.6}]'; //your json data
$jsonTable = json_encode($table, JSON_UNESCAPED_UNICODE);
$myObj = json_decode($jsonTable);
echo $myObj->name;

answered Mar 02 '15 at 18:37

Abdullah Al Shakib

2,034
2
15
16

score 0 · Answer 2 · answered Mar 02 '15 at 18:33

0

Try with this:

$table = utf8_encode($table);
$jsonTable = json_encode($table);

answered Mar 02 '15 at 18:33

zamarrowski

483
2
7

no, when i write $table['data'] = utf8_encode($rows); I get JSON with NO data – johny mile Mar 02 '15 at 18:36
I copied your code. So it works for me: $array = Array(); $array["test"] = "AlgoVital Plus čćš"; $jsonTable = json_encode($array); echo $jsonTable; – zamarrowski Mar 02 '15 at 18:42
@zamarrowski That means you don't need to call `utf_encode` ? – Ruan Mendes Mar 02 '15 at 18:43
Yes, in my example is not necessary. – zamarrowski Mar 02 '15 at 18:55

PHP PDO - Json encode with UTF-8

2 Answers2