Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: char vs varchar2
What are the effects on index size, optimisation, storage, if any?
In article <i6475.298$Mb4.4252010507_at_news.euroconnect.net>,
"Søren Junk" <sojudk_at_ifsas.dk> wrote:
> The basic difference between char and varchar2 is, that a varchar2
only
> takes up the space it needs, and a char takes up the whole length
(trailing
> spaces are added).
>
> This means that if you have an empty string, the varchar2 will treat
it as
> an empty string, but a char will treat is a a number of spaces.
>
> Regards
>
> Søren Junk
>
> gi <gi_at_england.com> wrote in message
> news:nlZ65.2368$Dr3.145427_at_monolith.news.easynet.net...
> > Can someone tell me ...but who really knows
> > if I have filled with length is there any difference if I use char
(1) or
> > varchar2(1)
> > I read somewhere that char is there only because COBOL programs but
I'm
not
> > sure is that true
> > Thanks
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Jun 30 2000 - 00:00:00 CDT