Received: from cortex.unice.fr (cortex.unice.fr [134.59.53.1]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5QMBSa91722 for ; Tue, 26 Jun 2001 18:11:28 -0400 (EDT) (envelope-from alet@unice.fr) Received: from nordine.ateur (adp-01.unice.fr [134.59.69.10]) by cortex.unice.fr (8.8.5/8.8.5) with ESMTP id AAA10756 for ; Wed, 27 Jun 2001 00:11:22 +0200 Received: from jerome by nordine.ateur with local (Exim 3.12 #1 (Debian)) id 15F138-0000Kr-00 for ; Wed, 27 Jun 2001 00:11:10 +0200 Date: Wed, 27 Jun 2001 00:11:10 +0200 From: Jerome Alet To: pgsql-sql@postgresql.org Subject: Storing image contents in TEXT fields Message-ID: <20010627001110.A1279@nordine.ateur> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i X-Archive-Number: 200106/423 X-Sequence-Number: 3720 Hi, I wanted to know if it's possible to store an image content in a TEXT field, or if another type is needed (in this case, then which one ?). I don't want to use BLOBs, because I modify an existing application which also works with MySQL, and I can't update to postgresql-7.1.x (I don't admin this server) in a TEXT field the image seems to be truncated at the first nul byte. Thanks in advance for any help. bye, Jerome Alet