Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6O49bf31757 for ; Tue, 24 Jul 2001 00:09:37 -0400 (EDT) (envelope-from Inoue@tpf.co.jp) Received: (qmail 521 invoked from network); 24 Jul 2001 04:09:36 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 24 Jul 2001 04:09:36 -0000 Received: from tpf.co.jp ([126.0.1.68]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id NAA17760; Tue, 24 Jul 2001 13:09:34 +0900 (JST) Message-ID: <3B5CF554.26270142@tpf.co.jp> Date: Tue, 24 Jul 2001 13:11:00 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Ashley Clark CC: Postgres Interface List Subject: Re: BYTEA and ODBC driver References: <20010723133931.A2422@ghoti.org> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/96 X-Sequence-Number: 1850 Ashley Clark wrote: > > Shouldn't I be able to store images in a field of BYTEA type? I keep > getting errors saying that I can't store that kind of information in a > field of that type. I'm using the latest ODBC driver (7.01.0006). > BYTEA type seems unavailable for your purpose. You seem to have to use large objects. See http://odbc.postgresql.org/ (FAQ). regards, Hiroshi Inoue