VARCHAR(50), CHAR(50) or TEXT ?

From: Henrik Steffen <webmaster(at)city-map(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: VARCHAR(50), CHAR(50) or TEXT ?
Date: 1999-05-13 09:08:31
Message-ID: 373A968F.A978EBBD@city-map.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello all,

in my database I have a field that will contain never more than 50
characters.

What is the type of choice?

TEXT, CHAR(50) or VARCHAR(50)

I neither want to waste diskspace, nor to slow down data processing.

Thanks,

Henrik
http://www.Stade.net/

Browse pgsql-sql by date

  From Date Subject
Next Message Hiroshi Inoue 1999-05-13 10:28:49 [HACKERS] spinlock freeze ?(Re: INSERT/UPDATE waiting (another example))
Previous Message Henrik Steffen 1999-05-13 09:06:28 TEXT, VARCHAR(50) or CHAR(50)?