p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

beginning_php thread: difference between VARCHAR and TEXT


Message #1 by "Yao Minfeng" <mscxmy@c...> on Thu, 22 Jul 2032 22:31:53 +0100
Dear friends,



I want to know if the only difference between the varchar and text is 

their size?



Cheers





----------------------------------------------



Yao Minfeng





School of Computing

University of Leeds



Leeds, United Kingdom



Message #2 by "Richard A. Holmes(personal)" <holmesra@w...> on Mon, 23 Jul 2001 17:05:22 -0600
Nope, (i think) 

Text would be text only (i.e. letters and such) INT would be numbers only

and VarChar would be Combo of both 



-----Original Message-----

From: Yao Minfeng [mailto:mscxmy@c...]

Sent: Thursday, July 22, 2032 3:32 PM

To: beginning php

Subject: [beginning_php] difference between VARCHAR and TEXT





Dear friends,



I want to know if the only difference between the varchar and text is 

their size?



Cheers





----------------------------------------------



Yao Minfeng





School of Computing

University of Leeds



Leeds, United Kingdom
Message #3 by "Hermawan Haryanto" <hermawan@h...> on Wed, 25 Jul 2001 21:42:52
Helo there,

I think what Yao Minfeng ask is the differences between Varchar and Text, 

not INT.

Yes, the differences is only the size, the VARCHAR can only handle 255 

character, but TEXT can handle a lot more character then VARCHAR, but 

LONGTEXT can handle a lot more character then TEXT.



Thanks

Hermawan Haryanto <hermawan@h...>



> Nope, (i think) 

> Text would be text only (i.e. letters and such) INT would be numbers only

> and VarChar would be Combo of both 

> 

> -----Original Message-----

> From: Yao Minfeng [mailto:mscxmy@c...]

> Sent: Thursday, July 22, 2032 3:32 PM

> To: beginning php

> Subject: [beginning_php] difference between VARCHAR and TEXT

> 

> 

> Dear friends,

> 

> I want to know if the only difference between the varchar and text is 

> their size?

> 

> Cheers

> 

> 

> ----------------------------------------------

> 

> Yao Minfeng

> 

> 

> School of Computing

> University of Leeds

> 

> Leeds, United Kingdom

  Return to Index