[PHPwestoz] [OT] MySQL UNIQUE INDEX

Leon Brooks leon at cyberknights.com.au
Mon Feb 21 16:23:02 UTC 2005


On Monday 21 February 2005 13:52, Evan Barter wrote:
> Timothy White wrote:
>> What's the difference between VARCHAR and TEXT?

> As far as I know, VARCHAR is fixed length while TEXT is dynamic.
> There maybe more differences, but that's the main one off the top of
> my head.

Both are dynamic. VARCHAR without a length is the same as TEXT in 
PostgreSQL, but IIRC while you can't say TEXT(80) to limit the size of 
the field, you can say VARCHAR(80).

Cheers; Leon

-- 
http://cyberknights.com.au/     Modern tools; traditional dedication
http://plug.linux.org.au/       Member, Perth Linux User Group
http://osia.net.au/             Member, Open Source Industry Australia
http://slpwa.asn.au/            Member, Linux Professionals WA
http://linux.org.au/            Member, Linux Australia




More information about the PHPwestoz mailing list