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

From: Henrik Steffen <webmaster(at)city-map(dot)de>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: TEXT, VARCHAR(50) or CHAR(50)?
Date: 1999-05-13 09:06:28
Message-ID: 373A9614.A415D5CE@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 Henrik Steffen 1999-05-13 09:08:31 VARCHAR(50), CHAR(50) or TEXT ?
Previous Message Ole Gjerde 1999-05-13 07:28:40 Re: [SQL] JOIN index/sequential select problem