Re: char, varchar2 confused?

This is what I exactly thought but it is as I said. I cannot figure it out. This is very wierd. No idea why this is occuring!

Reza wrote:

> Hi
> Don't you think this is other way round, I have never experienced such
> problem with VARCHAR datatype.
> It is CHAR type which always creates files with constant size.
> Regards
> Reza
> Sebastian Degenaar <degenaar_at_adlink.com.au> wrote in message
> news:383B3F77.C530010E_at_adlink.com.au...
> > If I do a sql statement within oracle 8i on Win NT on a varchar2 field
> > such as
> > select * from accounts where account_type = 'whatever' I have to pad the
> > 'whatever' with spaces to reflect the length of the field. However if I
> > change the field type to char, I don't have to pad and it works fine. I
> > don't get this.
> >
> > Any advice greatly appreciated
> >
> > Cheers!
> >
Received on Wed Nov 24 1999 - 04:29:24 CST