UTF8 mysql编码的数据库字段只显示php页面中的特殊字符

Question

I have a database field with utf8_unicode_ci encoding in MySQL. This arrangements done by the previous developer and it's store arabic language data in some special character format like this:

رنا كلبونه

I have set the headers to <meta http-equiv="Content-type" value="text/html; charset=utf-8" /> but its not showing the arabic language characters when I try to fetch the values from the database. It's only showing these special characters instead of the language.

Answer 1

If you are using MySQL then use below after DB connection

mysql_query("SET NAMES utf8");

If you are using MySQLi then use below after DB connection

mysqli_set_charset($connection,"utf8");

If you are using class and object of mysqli then use below

$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->set_charset("utf8");

Hope this will help !