Large data editor length in bytes incorrect - Allround Automations forums

Register Log In

Forums Products PL/SQL Developer Large data editor length in bytes incorrect

Print Thread

Large data editor length in bytes incorrect #64078 07/15/22 02:16 PM
Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL koja OP Member
OP koja Member Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL	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? Certainty of death, small chance of succes, What are we waiting for... (Gimly)

Re: Large data editor length in bytes incorrect koja #64084 07/18/22 09:06 AM
Joined: Aug 1999 Posts: 22,219 Marco Kalter Member
Marco Kalter Member Joined: Aug 1999 Posts: 22,219	Can you let me know the character set for these columns? Marco Kalter Allround Automations

Re: Large data editor length in bytes incorrect koja #64086 07/18/22 01:27 PM
Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL koja OP Member
OP koja Member Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL	Hi Marco, Code 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. Certainty of death, small chance of succes, What are we waiting for... (Gimly)

Re: Large data editor length in bytes incorrect koja #64725 07/18/23 10:04 AM
Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL koja OP Member
OP koja Member Joined: Mar 2007 Posts: 110 Hazerswoude-Dorp, NL	Large data editor still displays twice the length in version 15.0.4. Certainty of death, small chance of succes, What are we waiting for... (Gimly)

Moderated by support

Link Copied to Clipboard

Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)

Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 14 (0.009s) Memory: 2.5109 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-15 22:53:48 UTC
Valid HTML 5 and Valid CSS