SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer & sqlcl Encoding issue - special Characters

User_CGDSXJun 4 2018 — edited Jun 5 2018

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2018

Added on Jun 4 2018

#sql-developer

6 comments

2,586 views