Re: char vs. varchar?

From: John Smith <john_at_smith.com>
Date: Fri, 2 Feb 2001 14:13:31 -0000
Message-ID: <hBpe6.7$J2.2154@news.deakin.edu.au>

Is there any reason to choose CHAR(1) over VARCHAR2(1)?

Phil Carter.

"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:Y95e6.350392$U46.10584292_at_news1.sttls1.wa.home.com...
> Char - fixed length
> varchar - variable length
>
> use varchar.
> Jim
> "Tom Weng" <tomweng_at_home.com> wrote in message
> news:eS3e6.269797$hD4.65146495_at_news1.rdc1.mi.home.com...
> > Could somebody explain to me how Oracle store char datatype data vs.
varchar
> > datatype internally?
> >
> > Whis is the pro/con in-term of performing update on a char column v.s
> > varchar column?
> >
> >
> >
>
>
Received on Fri Feb 02 2001 - 08:13:31 CST