Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> VARCHAR2(1) vs CHAR(1)

VARCHAR2(1) vs CHAR(1)

From: Kees Hollenbach <KeesH_at_discoveryhealth.co.za>
Date: Tue, 27 Jun 2000 07:49:00 +0200
Message-Id: <10540.110494@fatcity.com>


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).

Thanks



NOTICE - This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message, you are hereby notified that you must not disseminate, copy or take any action in reliance on it. If you have received this message in error, please notify Discovery Health, immediately.

Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the view of the Discovery Health Ltd.


Received on Tue Jun 27 2000 - 00:49:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US