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.
On Tue, Sep 9, 2008 at 8:24 AM, Krishna Chandra Prajapati
> 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