开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜