I have a database table where I have some values containing the special letters æ, ø or å.
Upon fetching them it seems Ø turns into a simple "?":
Code: Select all
$sql = "SELECT description, count(description) AS count FROM userdata WHERE datetime like '".$datetime."%' GROUP BY description ORDER BY count DESC LIMIT 1";
$result = mysql_query($sql);
$descres= mysql_fetch_array($result);
echo "description:" . $descres['description'] ;Here is an example of output - the value should have been "SØ" like it is in the database:
"description:S�"
Great if someone have some idea why.
Darla