Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: char vs varchar2
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
>
>
Received on Fri Jun 30 2000 - 00:00:00 CDT