Hello
I have a problem on retrieving some fields from the Database. The data in the fields are written with Greek fonts.
In the mysql the data are viewed correctly the problem is when I am trying to print them out.
In properties of the mysql fields I have CHARACTER SET utf8 COLLATE utf8_unicode_ci
I also have tried to use instead of ‘utf8’ ‘greek’ in this line —- mysql_query(“SET NAMES ‘utf8′”, $connection);
Please help
Thank you
[code]
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=”http://www.w3.org/1999/xhtml”>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
<title>Untitled Document</title>
</head>
<body>
<?php
require(“config.php”);
$connection = mysql_connect($db_host, $db_user, $db_password) or die(“error connecting”);
mysql_select_db($db_name, $connection);
mysql_query(“SET NAMES ‘utf8′”, $connection);
$query = “SELECT * from area”;
$result = mysql_query($query, $connection);
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
$autoid = mysql_result($result, $i, “autoid”);
$area = mysql_result($result, $i, “area”);
echo $area;
}
?>
</body>
</html>