I my memory does not deceive me, there was once a discussion on this, and
some mentioned that VARCHAR2 takes up more space because it stores data in
16bytes rather than 8bytes.
Aleem
-----Original Message-----
From: Kees Hollenbach [mailto:KeesH_at_discoveryhealth.co.za]
Sent: 27 June, 2000 12:04 PM
To: Multiple recipients of list ORACLE-L
Subject: VARCHAR2(1) vs CHAR(1)
Can someone please tell me which datatype uses up more
diskspace : a
VARCHAR2(1) or a CHAR(1) field. A VARCHAR2 field supposedly
stores the data
in the field plus the field length (1 + 1 byte) while a CHAR
field only
stores the data (1 byte).
Received on Tue Jun 27 2000 - 02:08:51 CDT
