Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: varchar(2) use
You would not normally use varchar for field which have length lesser than
say 5.This is because varchar uses one byte for storage of the length of
the
actual data stored within the field.
Normally varchars would be used for fields greater than 5 and never user
varchar
for a field which is a single byte in length.
Regards
Sanjay Mathew
sanjay.mathew_at_burton.co.uk
YogitaT <yogitat_at_aol.com> wrote in article
<19970516231000.TAA00690_at_ladder02.news.aol.com>...
> can we use varchar2 if it is varchar2(1) and 100 or more such columns in
> our table instead of char(1) . Actually I want to know overhead defining
> column as varchar instead of char which is fixed.
> thanks
>
Received on Fri May 23 1997 - 00:00:00 CDT