Home > mailing lists

TEXT, VARCHAR(50) or CHAR(50)? - Mailing list pgsql-sql

From	Henrik Steffen
Subject	TEXT, VARCHAR(50) or CHAR(50)?
Date	May 13, 1999 05:09:08
Msg-id	373A9614.A415D5CE@city-map.de Whole thread Raw
List	pgsql-sql

Tree view

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/

pgsql-sql by date:

From: Ole Gjerde
Date: 13 May 1999, 03:41:57
Subject: Re: [SQL] JOIN index/sequential select problem

From: Henrik Steffen
Date: 13 May 1999, 05:10:48
Subject: VARCHAR(50), CHAR(50) or TEXT ?

TEXT, VARCHAR(50) or CHAR(50)? - Mailing list pgsql-sql

Previous

Next