Received: from athena.evoserve.com (athena.evoserve.com [210.16.1.33]) by hub.org (8.9.2/8.9.1) with ESMTP id HAA67590 for ; Fri, 19 Feb 1999 07:03:30 -0500 (EST) (envelope-from brianb@athena.evoserve.com) Received: (from brianb@localhost) by athena.evoserve.com (8.8.8/8.7.3) id UAA15572; Fri, 19 Feb 1999 20:03:03 +0800 (GMT+0800) Date: Fri, 19 Feb 1999 20:03:03 +0800 (GMT+0800) From: Brian Baquiran To: Ghita Voda cc: "'pgsql-sql@postgresql.org'" Subject: Re: [SQL] Insert a long text In-Reply-To: <01BE5BFF.7F998C30@oak.smartsoft.ro> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Fri, 19 Feb 1999, Ghita Voda wrote: > Hello! > > I want to insert a long text (up to 10.000 words) into a table (for example, table1) into a field (field1) which is a 'text' field. > I have tried the followings: > INSERT INTO table1 VALUES (' long text'...) > UPDATE table1 SET field1='long text' > and is not working. > I'm using servlets and Apache server, on Linux. What data type are you using for the text field? As far as I know, the 'text' datatype can only take 8K. I don't know what the maximum size for varchar is. Brian -- "No matter how cool your interface, it would be better if there were less of it" -- Alan Cooper