phpMyAdmin 中不显示阿拉伯字符

所以我目前正在从事某个项目,我需要创建一个数据库,其中的记录将同时包含英语和阿拉伯语名称.

So I am currently working on a certain project where I need to create a database in which its records will hold both English and Arabic names.

我使用 PhpMyAdmin 创建它,它对于英文名称非常有效,但是所有阿拉伯名称都显示为?????".

I am creating this using PhpMyAdmin where it works perfectly fine for English names, however all the Arabic names appear as "?????".

为了解决这个问题,我尝试使用set name 'utf8'",但是没有用.谷歌搜索这个问题,我意识到 PhpMyAdmin 不支持阿拉伯语或特殊字符.

To solve this issue I tried to use "set name 'utf8' ", however it didn't work. Googling this problem I realized that PhpMyAdmin does not support either Arabic or Special characters.

我不确定是否有解决此问题的方法.您有什么建议可以解决吗?

I am not sure if there is any workaround for this issue. Do you have any suggestion to solve it ?

提前致谢

推荐答案

首先,您的数据库是否能够存储 Unicode?SHOW CREATE TABLE table_name; 希望将您的字符集显示为 utf8.如果不是,这应该解决它:

First, is your database capable of storing Unicode? SHOW CREATE TABLE table_name; will hopefully show your character set as utf8. If not this should fix it:

ALTER TABLE table_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

还要确保您的 PHPMyAdmin 设置包含以下内容:

Also make sure your PHPMyAdmin settings contain this:

$cfg['DefaultCharset'] = 'utf_8';
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';

相关文章