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 <[EMAIL PROTECTED]> 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]