阿拉伯语不能在我的主页中正确显示

Question

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

$sql = "SELECT * FROM mytable";
$data = selectArray($sql);

insert arabic data is = `تظهر البيانات العربي

display in my database = تظهر البيانات العربيØ

display in cakePhp = تظهر البيانات العربية (display proper)

display in corePhp = تظهر البيانات العربيØ

Let me know any one have solution of this issue.

Answer 1

when create table use like this CREATE DATABASE mydb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;