1

I have imported an EXCEL File to mySQL database. The database is imported but when it comes to arabic chars they don't appear. it gives me blank fields. The steps I used : 1- Save the Excel as CSV. 2- Import from mysql

ama989
  • 463
  • 1
  • 5
  • 23
  • The CSV would have been saved in your machine's default encoding; did you tell MySQL that was the file's character set upon import? – eggyal Sep 08 '15 at 08:27
  • I choose the char as utf8. And when importing, the records which contain arabic data it says "Affected". Do I have to change the encoding from the Excel first ? – ama989 Sep 08 '15 at 08:30

1 Answers1

2

My recommendation is Excel2MySQL. It will handle all possible unicode characters. There are also other options that can import unicode... see this post: How to import an excel file in to a MySQL database

Community
  • 1
  • 1
panofish
  • 7,578
  • 13
  • 55
  • 96