Horton

Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?

Brett W. McCoy <bmccoy@lan2wan.com>

View thread View on postgr.es
From: "Brett W. McCoy" <bmccoy@lan2wan.com>
To: henrik@steffen.stade.net
Cc: Mark Jewiss <mark@office.knowledge.com>, pgsql-sql@postgreSQL.org
Date: 1999-05-13T11:49:23Z
Lists: pgsql-sql 
On Thu, 13 May 1999, Henrik Steffen wrote:

> Thanks for you quick response.
> 
> I understand the difference between CHAR and VARCHAR now.
> 
> But, what is the difference between VARCHAR and TEXT ?

Text fields have no explicit upper limit.  They are kinda like memo
fields in Access, except you *can* index them in PostgreSQL.

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
Never get into fights with ugly people because they have nothing to lose.