How to insert the arabic data into mysql tables is a tedious question .but mysql has supported the arabic data
In mysql we can perform operation in different languages .But for that we need to enable the utf-8,which is not enables by default.
We can achieve this by change the collation of the table.
we can change it for the whole database, or a single table or all per required .
For changing the whole database collation , select the database than click on operation and change the collation.
Same thing can be done for a particular table ,click on table than click on operation and change the collation.
We can do this by changing the Collation in mysql table. At the time of creating a new table or altering the existing table.
That is to say ,Collation is set by default on newly created tables.
We can easily change the Collation’s default value to utf8_general_ci by change option given in above image in phpmyadmin collation becomes :-
Now you can ,insert arab language data or any other utf-8 supported character in this table of mysql.