How can i display chines characters from mySQL?

Question

I'm helping for my school website,and then i try to display some data form the database,the image source and link is work just fine,but when try to display some chines string,is became ?????,my PHP document is already using UTF-8 and same as SQL utf8_unicode_ci,but is still showing some ?????

Showing content code:

header('Content-Type: text/html; charset=UTF-8');
$getNews = mysql_query("SELECT * FROM news");
while ($rows = mysql_fetch_array($getNews)) {
$img = $rows['img'];
$title = $rows['title'];
$link = $rows['link'];
echo '<div class="showNewsBox">';
  echo '<div class="showNews">';
   echo "<a href='$link' target='_blank'>";
    echo "<img src='$img' class='newsImage'>";
    echo "<h3 class='newsTitle'>" . $title . "</h3>";
   echo "</a>";
 echo "</div>";
}

PHP UTF-8 code

<meta charset="utf-8">

Possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) — Matt Raines, Jun 25 '16 at 10:19

score 0 · Answer 1 · edited May 23 '17 at 12:16

0

I think most voted answer of this question below will solve your problem: Can't insert Chinese character into MySQL

In short: set charset as UTF-8 when reading and writing to DB

mysql_query("SET character_set_client=utf8", $dbLink); 
mysql_query("SET character_set_connection=utf8", $dbLink);

edited May 23 '17 at 12:16

Community

1
1

answered Jun 25 '16 at 07:56

Sepehr Raftari

1

Lokesh Jain · Answer 2 · 2016-06-25T08:23:11.293

0

Just go to your database table structure and set collation utf8_unicode_ci for column which you want to display in chines!

edited Jun 25 '16 at 08:23

answered Jun 25 '16 at 08:04

Lokesh Jain

579
6
19

How can i display chines characters from mySQL?

2 Answers2