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> Link to comment https://forums.phpfreaks.com/topic/65948-problem-printing-greek-fonts/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.