oracle 使用oracle sql developer将utf-8数据导出到文本文件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1801442/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
export utf-8 data to text file with oracle sql developer
提问by robinmag
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 ?
我需要以插入语句的形式将 urf-8 数据导出到文本文件。我试过 Oracle SQL 开发人员的导出数据工具。但是它使用ansi编码将数据导出到txt文件，因此utf-8字符变成“？” 标记。我想知道是否可以使用 utf-8 编码导出数据？
Thank you.
谢谢你。
回答by Vincent Malgrat
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.
您可以使用 Sql Developer 以 UTF-8 格式导出数据。确保您的客户端 NLS 参数设置正确。如果您使用的是 Windows，这些设置在注册表中。还要确保在 Sql Developer 的设置面板中选择了 UTF-8 作为编码字符集。
