Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: char, varchar2 confused?
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 - 03:59:41 CST