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';

这篇关于phpMyAdmin 中不显示阿拉伯字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持html5模板网！