2

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.

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

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 ?

Thanks in advance

user3071512
  • 23
  • 1
  • 2
  • 4

5 Answers5

3

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;

Also make sure your PHPMyAdmin settings contain this:

$cfg['DefaultCharset'] = 'utf_8';
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
miken32
  • 42,008
  • 16
  • 111
  • 154
1

phpMyAdmin has no problem with UTF8, which as far as I can tell means Arabic has been fully supported for some time. phpMyAdmin just shows (accurately) what is stored in your database; if you're not seeing what you expect it's almost always because your application is misbehaving. Perhaps your Google search turned up quite old information; I'm not sure how long phpMyAdmin has supported these special characthers but looking at the development log file it seems that it's been at least since 2008, and almost certainly even prior to that. Anyway:

The phpMyAdmin wiki has considerable detail on the matter and is a good place to start. There's also a quite comprehensive guide here at Stackoverflow, or this link to another very similar question. You can read more about properly setting the application charset here, and I'll refer you once again to the phpMyAdmin wiki for information on recovering/repairing the situation.

To summarize: the problem is almost certainly in how your application stores data, not how phpMyAdmin displays it. Make sure your database and tables are using a utf character set. In your application code, make sure you set your connection charset properly. Recovery is rather painless and can be achieved by switching the column charset first to binary then whatever utf8-variant makes the most sense for you.

Isaac Bennetch
  • 11,830
  • 2
  • 32
  • 43
1

Add these 2 line at bottom of the my.ini file. then restart the wamp server.

character-set-server=utf8    
collation-server=utf8_general_ci

enter image description here

Sandeep Sherpur
  • 2,418
  • 25
  • 27
0

This worked for me :

ALTER DATABASE database_name CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

UPDATE table_name SET column_name = CONVERT(BINARY CONVERT(column_name USING latin1) USING utf8mb4)

And if some characters cause problem while changing into latin1 then try this:

UPDATE comments SET name = CONVERT(BINARY CONVERT(name USING binary) USING utf8mb4);
Mursaleen Ahmad
  • 23
  • 6
-1

Fisrt of all navigate to the following link: http://localhost/phpmyadmin/index.php enter image description here

make the Server connection collation: utf8_unicode_ci And all the Arabic data fields will be displayed in the phpMyAdmin Databases.

Younes Da
  • 1