List:General Discussion« Previous MessageNext Message »
From:Terry Riley Date:September 9 2008 12:44pm
Subject:Re: DATATYPES
View as plain text  
Suggest you read the online manual.......

----- 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 13:44:05
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