Recently I've upgraded my SQLcl from the version 23 to 25.2 and been facing a weird problem since then.
When running SQLcl commands, the output shown in the terminal can't translate well the characters and instead shows a bunch of ‘?’. I know it is a encoding problem, just don't know why it worked fine in the earlier version and now this problem appeared.
Example:
select 'áÃéÕ' from dual;
Correctly outputs áÃéÕ
But if put the command in a file and use GET <path>/script.sql it displays:
select '????' from dual
Similarly, when extracting the source code from the database via the command DDL <object> SAVE <path> it creates a file in UTF-8 when the older version would output the file in the format that I use, Windows-1252.
I use Windows Terminal with the 1252 active page.
My SQLcl encoding is set to Windows-1252
Database charset: WE8MSWIN1252