Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

I have a table in MSQL database with arabic text in one of its columns but when i exported it to csv, It is getting converted to some other format say like

احتÙاÙ

I want my arabic text to be exported instead. I think there is an issue with encoding. PLease help.

like image 539
kkoe Avatar asked Dec 03 '15 06:12

kkoe


People also ask

How do I export data from Toad to CSV?

In the Export Data window, select the options as shown in below image to export the data into CSV file from Toad. Select the option Delimited Text from the Export Format drop-down. Specify the file location and name in File field. Specify the delimiter and click OK to export.

How do I export a MySQL database to a text file?

The simplest way of exporting a table data into a text file is by using the SELECT... INTO OUTFILE statement that exports a query result directly into a file on the server host.


1 Answers

I had the same problem before but I used to save as OpenDocument Spreadsheet and then open it by Excel. You may face some issues like slow save in excel but it is work, worth to try.

like image 132
hussam Avatar answered Sep 30 '22 10:09

hussam