You pretty much answered your own question. A char will always use the
same amount of space (the max size), regardless of how little data you
put in it. A varchar will only use enough space to store the data, so
the amount of space used for each record will be different. You can
also specify a max size for varchar. Text is like varchar, but with a
"fixed" max size of 65,000 characters.
Brent Baisley
On Tue, Sep 9, 2008 at 8:24 AM, Krishna Chandra Prajapati
<prajapatikc@stripped> wrote:
> Hi,
>
> I would like to know the difference between char, varchar and text.
>
> char limit 255 character fixed length
> varchar limit 65,000 character variable length
> text limit 65,000 character variable length.
>
> --
> Krishna Chandra Prajapati
>
