Thread

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

    Henrik Steffen <webmaster@city-map.de> — 1999-05-13T11:14:15Z

    Hello Mark,
    
    Thanks for you quick response.
    
    I understand the difference between CHAR and VARCHAR now.
    
    But, what is the difference between VARCHAR and TEXT ?
    
    
    Kind regards
    
    Henrik Steffen
    http://www.TopConcepts.de/
    
    
  2. Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?

    Brett W. McCoy <bmccoy@lan2wan.com> — 1999-05-13T11:49:23Z

    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.