Re: CHAR vs VARCHAR

In short, a char will pad with spaces to make up the space, a varchar will now.

e.g

CHAR(4) stores A as ' A'
VARCHAR2(4) stores A as 'A';

M

"Paul Pruchnik" <paulrp_at_earthlink.net> wrote in message news:<5eria.3978$ey1.309583_at_newsread1.prod.itd.earthlink.net>...
> Greetings,
> What is the savings of CHAR(4) vs VARCHAR(4) for storing a 4 (required)
> character code? What is the overhead in using VARCHAR for fields of required
> length?
> Thanks,
> -Paul Pruchnik
Received on Wed Apr 02 2003 - 01:41:56 CST