Received: from cloud.ndh.net (cloud.ndh.net [195.94.94.16]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA19113 for ; Thu, 13 May 1999 05:10:48 -0400 (EDT) (envelope-from webmaster@city-map.de) Received: from ppp05231.01019freenet.de ([212.81.148.111] helo=city-map.de) by cloud.ndh.net with esmtp (Exim 2.05 #1) id 10hqfF-0002LF-00 for pgsql-sql@postgreSQL.org; Thu, 13 May 1999 10:16:21 +0200 Message-ID: <373A968F.A978EBBD@city-map.de> Date: Thu, 13 May 1999 11:08:31 +0200 From: Henrik Steffen Reply-To: henrik@steffen.stade.net Organization: city-map X-Mailer: Mozilla 4.5 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: VARCHAR(50), CHAR(50) or TEXT ? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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/