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 en开发者_如何学运维coding to export data ?
Thank you.
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
精彩评论