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

Home -> Community -> Usenet -> c.d.o.server -> Re: char vs. varchar?

Re: char vs. varchar?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 03 Feb 2001 16:10:14 +0100
Message-ID: <3A7C1F56.C8009BD@0800-einwahl.de>

Which overhead is implied in using VARCHAR2 (1) as compared to CHAR (1)?

I claim there is no such overhead. Both are stored as variable length data. You can see that by examining with vsize and dump.

Martin Received on Sat Feb 03 2001 - 09:10:14 CST

Original text of this message

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