How to insert the arabic data into mysql tables

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.

one

We can easily change the Collation’s default value to utf8_general_ci by change option given in above image in phpmyadmin collation becomes :-two

Now you can ,insert arab language data or any other utf-8 supported character in this table of mysql.

How to use php mysql with arabic data

check for the UTF-8 Documentation

Leave a Reply

Your email address will not be published. Required fields are marked *