encoding - SQL Developer 口音编码

Question

您好我正在构建一个简单的导出脚本，但路径有重音符号（特殊字符）´~ç`

如何强制 SQL Developer 使用正确的编码？

set feedback off
set nls_date_format = 'YYYY-MM-DD HH24:MI:SS'
set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SSXFF'
set nls_lang=PORTUGUESE_PORTUGAL.WE8ISO8859P1 
set echo off
set encoding UTF-8
set SQLFORMAT csv

column dcol new_value SYSDATE 
column dest new_value VARCHAR2
select to_char(sysdate,'DD-MM-YYYY') dcol from dual;
select 'Y:\Operação Logística\' dest from dual;

结果：

"DCOL" 
"04-06-2018" 
"DEST" 
"Y:\Operação Logística\"

标签： encodingoracle-sqldeveloperspecial-characters