Return
-
Title
Unicode database. Performing a DESCRIBE or DESC on a table with CHAR columns shows up as 4 times -
Description
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.