Received: from cloud.ndh.net (cloud.ndh.net [195.94.94.16]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA18758 for ; Thu, 13 May 1999 05:09:07 -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 10hqdn-0002L3-00 for pgsql-sql@postgreSQL.org; Thu, 13 May 1999 10:14:51 +0200 Message-ID: <373A9614.A415D5CE@city-map.de> Date: Thu, 13 May 1999 11:06:28 +0200 From: Henrik Steffen 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: TEXT, VARCHAR(50) or CHAR(50)? 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/