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

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

Up vote 0 down vote favorite share g+ share fb share tw.

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 database 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 mysql database character-encoding phpmyadmin link|improve this question asked Apr 27 '11 at 14:20Peter61.

Looks like a question for serverfault. Anyway, check that your dump is in UTF8 and mhmmyadmin is set up to accept UTF8 dump. Also check your database and tables' encodings - it should also be UTF8.

– Victor Sergienko Apr 27 '11 at 14:23.

– Peter Apr 27 '11 at 14:29 after is too late. – Capsule Apr 27 '11 at 14:31.

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.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.