spyros1234 Posted August 21, 2007 Share Posted August 21, 2007 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 <!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> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.