Have you checked the manual to be sure that the 65000 varchar is
available to the version of MySQL you are using? Prior to 5.0.3, it was
255 only.
----- Original Message -----
> *From:* "Krishna Chandra Prajapati" <prajapatikc@stripped>
> *To:* mysql <mysql@stripped>
> *Date:* Tue, 9 Sep 2008 17:54:46 +0530
>
> 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
>
>
>
> ---
> avast! Antivirus: Inbound message clean.
> Virus Database (VPS): 080908-0, 08/09/2008
> Tested on: 09/09/2008 13:40:08
> avast! - copyright (c) 1988-2008 ALWIL Software.
> http://www.avast.com
>
>
>
Terry
http://www.confexdb.co.uk/
---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080908-0, 08/09/2008
Tested on: 09/09/2008 14:58:55
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com
