MariaDB 10.2 json插入对PHP无效

Question

I'm trying to save a lot of data inside my MariaDB 10.2 database with JSON. The data contain's ' " / \ | and a lot more special characters.

When I do json_encode and after that directly json_decode I got a nice working array, however, when I use json_encode and saves it to the database and after I select the column and do json_decode it will return NULL in PHP. Also JSON_VALID('ms_routing_data') in SQL returns mostly 0.

Before this, all my data was stored serialized in the database without having problems with special characters.

Here I have an example of my script and data from my database. https://pastebin.com/EWvFr10p

Answer 1

I got my problem solved. It was easier than I thought it would be.

I can just use the most basic variant of json_encode() without flags. All I needed to is adding mysqli_real_escape_string() on my insert. Now all my data returns valid JSON.