0

I have Movie Titles in Non-English scripts like Hindi, Korean, Japanese which are stored in my MySQL database. However when I do a select query on the table the titles are being displayed as "??". Any pointers what might be going wrong?

I checked the Encoding for the database using SHOW VARIABLES LIKE "character\_set\_database"; and it comes to UTF-8.

Antti Haapala -- Слава Україні
  • 129,958
  • 22
  • 279
  • 321
Sameervb
  • 381
  • 3
  • 5
  • 15

1 Answers1

0

Try this code while you are connection with server. May be it can help you.

$con=mysql_connect("hostname","username","password");

mysql_query("SET CHARACTER SET utf8",$con);

And check also This Post and this article.

Community
  • 1
  • 1
Kaushal Khamar
  • 2,097
  • 1
  • 17
  • 23