PHP MySQL Greek letters showing like ???? marks

Question

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

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

Anyone know how to fix this error thank you.

Answer 1

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

Answer 2

Try this:

mysqli_set_charset($con, "utf8");

After you connect to DB.