I'm having some problem getting text with special characters (Swedish: "åäö") from the database.
If I just do a normal query,
"SELECT * FROM"
and the echo
out the result:
while($row = mysql_fetch_assoc($result))
{
echo $row['text'];
}
... the result is fine.
However, when doing json_encode($array)
, the special characters have been replaced:
{"id":"1","question":"fr\u00e5ga \u00e5\u00e4\u00f6"....
I don't know how many different things I tried, including converting the database to UTF-8, fields to utf8_general_ci
, utf8_encode($string)
, utf8_decode($string)
, ....