Performing a DESCRIBE or DESC on a table with CHAR columns shows up as 4 times the size or is multiplied by four. For example, VARCHAR2(10) is showing up as VARCHAR2(40).
This happens only on Unicode / UTF8 / Multi-Byte databases. The issue happens on table columns that are created as i.e. COL1 VARCHAR2(10 CHAR). If the table datatype is created as i.e. COL1 VARCHAR2(10 BYTE), the problem does not happen.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center