How to import Arabic dump SQL file to phpmyadmin without problems?

Hey guys

I've converted a microsoft access database to use it in Mysql, the problem is there are some values in arabic, in the dump file they are fine, but when I import the database to phpmyadmin the arabic letters become like strange letters that can't be read, they are important in the databa开发者_运维百科se and I couldn't find a solution for that.

is there anything that I can do to fix this problem ? and thank you very much :D

You have to set your database, tables and fields collations to the right encoding. utf8_unicode_ci will probably be fine.

Instead of importing the sql file, copy the entire sql from the file and paste it in the SQL box. execute these statements. it will work. but make sure the fields which is going to store the arabic data should be utf8 collated