Large data editor length in bytes incorrect

[koja]

I noticed that the length in bytes as displayed in the bottom-right corner of the "large data editor" is twice the real data length. I checked for varchar2 columns and for clobs. Can this be fixed?

 

[Marco Kalter]

Can you let me know the character set for these columns?

 

[koja]

Hi Marco,

NLS_CHARACTERSET       AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_LENGTH_SEMANTICS   BYTE

length and lengthb both return the same value for those (byte length declared) columns, while the large data editor states twice that amount in bytes.

 

[koja]

Large data editor still displays twice the length in version 15.0.4.

 

[koja]

We have another issue now also with the large data editor, as it shows line ends with crlf, while in reality it's lf only (I have found the setting read LF as CR/LF from the database, but this doesn't seem to change behaviour). Also noticed that in Version 16.0.6.2170 that I now use the number of bytes / characters displayed is still twice the real number.