Re: CHAR vs VARCHAR

From: Chaz <news-dfn_at_chaz6.com>
Date: Wed, 2 Apr 2003 10:32:09 +0100
Message-ID: <b6ean1$4frai$1@ID-117927.news.dfncis.de>

"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
>
>

Where X is the field length, and N is the length of data,

CHAR uses X
VARCHAR uses N+1

Please read the manual, that's what it's there for! Received on Wed Apr 02 2003 - 03:32:09 CST