How to export arabic text from MySQL database to csv using toad for MySQL?

Question

I have a table in an MSQL database with Arabic text in one of the columns, but when I exported it to csv, it is converted to some other format, for example,

اØتÙا٠

I want Arabic text to be exported instead. I think there is a problem with the encoding. Help PLease.

Answer 1

I found the answer to this question. It is very simple.

I usually use quick export and save the table in CSV format.

Now, instead of exporting to CSV, if I exported it in excel format, Arabic text will appear :). I don't know why this happened, but it worked.

Please write if you know the best answer. Thanks:)

Answer 2

I used to have the same problem, but I usually saved it as an OpenDocument spreadsheet and then opened it in Excel. You may encounter some problems, such as slow saving in Excel, but this is a job worth trying.

Answer 3

Using Libreoffice means free, open source office software, and then switching to an Excel workbook.