Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

export utf-8 data to text file with oracle sql developer

I need to export urf-8 data to a text file in form of insert statement. I've tried Oracle SQL developer's export data tool. But it use ansi encoding to export data to txt file so utf-8 characters turn to "?" mark. I wonder how whether it's possible to use utf-8 encoding to export data ?

Thank you.

like image 876
robinmag Avatar asked Sep 06 '25 08:09

robinmag


1 Answers

You can export data in UTF-8 with Sql Developer. Make sure your client NLS parameters are setup correctly. If you're on windows these settings are in the registry. Make sure also that in the settings panel of Sql Developer you have selected UTF-8 as the encoding character set.

See Also

Oracle Unicode Spooling

like image 122
Vincent Malgrat Avatar answered Sep 10 '25 03:09

Vincent Malgrat



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!