Postgres Pro
Downloads
Home   >   mailing lists

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

From Henrik Steffen
Subject VARCHAR(50), CHAR(50) or TEXT ?
Date
Msg-id 373A968F.A978EBBD@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:

Previous
From: Henrik Steffen
Date:
Subject: TEXT, VARCHAR(50) or CHAR(50)?
Next
From: Henrik Steffen
Date:
Subject: Re: [SQL] VARCHAR(50), CHAR(50) or TEXT ?