Alex Rivera | Logout

PHP MySQL Greek letters showing like ???? marks

Asked 2012-08-04T05:54:42.880
12

I have a table with some text and text is greek letters, when i use sql tool and select the data from this table is showing correctly Image for SQL Query Results

But when i show this my site frontend using mysql_fetch array and when echo it shows as below enter image description here

Anyone know how to fix this error thank you.

php mysql character-encoding
Edit
Report

1 Answer

20

try the following:

after you connect to the mysql, do this query to make sure that you are using UTF8: 

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

make sure that in HTML (head) you are using the right encoding, try: 

<meta http-equiv="content-type" content="text/html; charset=UTF-8">

if this does not help, try different encoding, like ISO-8859-1

answered 2012-08-04T06:32:49.310

Your Answer