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 varchar2

Re: char vs varchar2

From: <garreth1972_at_my-deja.com>
Date: 2000/06/30
Message-ID: <8ji2o2$38d$1@nnrp1.deja.com>#1/1

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

Original text of this message

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