SQLcl 23.1.0.88.2259 still not fully supporting UTF-8?
I'm surprised to learn that SQLcl 23.1.0.88.2259 still doesn't appear to fully support UTF-8.
I'm using:
Windows code page 65001 NLS_LANG=AMERICAN_AMERICA.AL32UTF8 SQLcl encoding UTF-8
against an Oracle Database EE 19.0.0.0.0 with character set AL32UTF8.
SELECT statements returning text literals with UTF-8 characters don't render correctly and editing such statements doesn't write afiedt.buf in UTF-8 encoding.
Example:
SQL> select 'abcæøåÆØÅABC' c1,
2 length('abcæøåÆØÅABC') c2,
3 dump('abcæøåÆØÅABC') c3
4* from dual;
C1 C2 C3
_______________ _____ ___________________________________________________________________________________
abcABC 12 Typ=96 Len=18: 97,98,99,195,166,195,184,195,165,195,134,195,152,195,133,65,66,67
Danish characters æøåÆØÅ are not displayed at all, despite length (12 characters) and DUMP are returning correct values. Also note that the column layout is completely messed up (C2 header starts too soon).
Tagged:
0