Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: VARCHAR2(1) vs CHAR(1)
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