json_encode and UTF-8

[konseptit]

I'm trying to store an array as json in Mysql
I have problems with special chars like æøå.
Input is in UTF-8, verified with mb_detect_encoding.

Code:

json_encode($values)." - ".var_export($values, true)

Result in MySQL:
{"6":"\u00e6\u00f8\u00e5","7":"test"} - array (
6 => 'æøå',
7 => 'test',
)

Why that bull**** characters in json_encode?
Thanks for help🙂

[Weedpacket]

One question is why you're storing json-encoded data in a database instead of just storing the data directly.

Another is the character encoding being used to display the output you're looking at (those garbled characters look like UTF-8 that's been displayed with the wrong encoding - probably ISO-8859-1).

A third is the character encoding/collation you're using in the database.

[konseptit]

Hi!

Forget this... n00bish🙂
I'm using it for direct output to some Ajax-calls...

I used serialize and unserialize functions, and then converted it to json.
It worked perfectly..