Hello I am building a simple export script, but the path has accents (special characters) ´~ç`
How can I force SQL Developer to use the correct encoding?
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;
Results:
"DCOL"
"04-06-2018"
"DEST"
"Y:\Operação LogÃstica\"
It shows the same output either in SQL Developer or in sqlcl.
How can I fix this?