Inserting JSON string into MySQL column UTF-8

Question

I am generating JSON valid string like: [{"head":"Model Name","body":"T102HA-GR015T"}]

The string generated on UTF-8 page with header('Content-Type: text/html; charset=utf-8'); and file encoding UTF-8.

The connection to database made by PDO with charset=utf8

DB table & column collations are utf8_general_ci

When it inserted to db it look like:

For Russian: [{"head":"\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u043c\u043e\u0434\u0435\u043b\u0438","body":"T102HA-GR015T"}]

For Hebrew: [{"head":"\u05d3\u05d2\u05dd","body":"T102HA-GR015T"}]

And I want it to be inserted to db in actual lang characters, like:

For Russian: [{"head":"Название модели","body":"T102HA-GR015T"}]

For Hebrew: [{"head":"דגם","body":"T102HA-GR015T"}]

phpMyAdmin screenshot:

Something (other than MySQL) is encoding it... See stackoverflow.com/documentation/php/617/json/2019/… — Rick James
– Rick James, Commented Dec 30, 2016 at 16:19
@RickJames thanks a lot, it helped me to resolve it with $array = json_encode($array, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES); — IncreMan
– IncreMan, Commented Jan 1, 2017 at 11:18

miken32 · Accepted Answer · 2017-09-21 18:54:00Z

2

Thanks to @RickJames for helping, solved using JSON_UNESCAPED_UNICODE

$array = json_encode($array, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES)

miken32

42.5k16 gold badges127 silver badges177 bronze badges

answered Jan 1, 2017 at 11:28

IncreMan

3563 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1