List:General Discussion« Previous MessageNext Message »
From:Terry Riley Date:September 9 2008 1:58pm
Subject:Re: DATATYPES
View as plain text  
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




Thread
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