CODEWITHSUNDEEP
mysqldatabasecharacter-encodingphpmyadmin
Peter
Peter

Reputation: 11

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 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

Upvotes: 0

Views: 1856

Answers (2)

Salam
Salam

Reputation: 11

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

Upvotes: 1

Capsule
Capsule

Reputation: 6159

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

Upvotes: 1

Related Questions