X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.193])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 79E9630FF9A; Thu, 26 Jun 2003 16:38:02 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new,
	port 10024)
	with ESMTP id 85501-05; Thu, 26 Jun 2003 13:37:52 -0300 (ADT)
Received: from internet.csl.co.uk (internet.csl.co.uk [194.130.52.3])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 6587D30FFC8; Thu, 26 Jun 2003 13:37:51 -0300 (ADT)
Received: from euphrates.csl.co.uk (host-194-67.csl.co.uk [194.130.52.67])
	by internet.csl.co.uk (8.12.8/8.12.8) with ESMTP id h5QGbriM028323;
	Thu, 26 Jun 2003 17:37:53 +0100
Received: from kelvin.csl.co.uk by euphrates.csl.co.uk (8.9.3/ConceptI 2.4)
	id RAA22804; Thu, 26 Jun 2003 17:37:48 +0100 (BST)
Received: from kelvin.csl.co.uk (localhost.localdomain [127.0.0.1])
	by kelvin.csl.co.uk (8.12.8/8.12.8) with ESMTP id h5QGbl8C018778;
	Thu, 26 Jun 2003 17:37:47 +0100
Received: (from lkind@localhost)
	by kelvin.csl.co.uk (8.12.8/8.12.8/Submit) id h5QGblxX018774;
	Thu, 26 Jun 2003 17:37:47 +0100
From: Lee Kindness <lkindness@csl.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <16123.8538.839179.120406@kelvin.csl.co.uk>
Date: Thu, 26 Jun 2003 17:37:46 +0100
To: pgsql-hackers@postgresql.org, pgsql-interfaces@postgresql.org
Subject: ECPG and bytea
X-Mailer: VM 7.07 under 21.4 (patch 12) "Portable Code" XEmacs Lucid
Cc: Lee Kindness <lkindness@csl.co.uk>
X-Archive-Number: 200306/80
X-Sequence-Number: 4291

Guys, surely some one's done this before? I've tried using
PQescapeBytea too, but still get (slightly) different output. If I try
and insert "\x02\x01\x02\x03\x04hello\x05\x64\x99\x45" I get (int
values of chars printed):

INSERT: 2   1   2   3   4 104 101 108 108 111   5 100 -103  69
SELECT: 2   1   2   3   4 104 101 108 108 111   5 100   92  50  51  49  69

hoping someone has a quick answer... if not I'll post a full source
example and look into it more...

Thanks, L.