Menu
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.
539
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.
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.
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.
132
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
