List:General Discussion« Previous MessageNext Message »
From:Brent Baisley Date:September 9 2008 12:48pm
View as plain text  
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
DATATYPESKrishna Chandra Prajapati9 Sep
  • Re: DATATYPESTerry Riley9 Sep
  • Re: DATATYPESBrent Baisley9 Sep
    • Re: DATATYPESKrishna Chandra Prajapati9 Sep
  • Re: DATATYPESTerry Riley9 Sep
    • Re: DATATYPESKrishna Chandra Prajapati10 Sep
  • Re: DATATYPESMartijn Tonies9 Sep
    • Re: DATATYPESKrishna Chandra Prajapati10 Sep