Received: from bastion.solipsys.com (bastion.solipsys.com [209.117.190.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id NAA42747
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 23 Jun 1999 13:39:41 -0400 (EDT)
	(envelope-from byronn@solipsys.com)
Received: from solipsys.com ([209.117.190.166])
	by bastion.solipsys.com (8.9.1a/8.9.1) with ESMTP id NAA09710;
	Wed, 23 Jun 1999 13:38:27 -0400 (EDT)
Message-ID: <37711BFE.1E6EEA3C@solipsys.com>
Date: Wed, 23 Jun 1999 13:40:14 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Robin Whitworth <rwhit@goldwiretech.com>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC & bytea
References: <377103C7.D695CB9E@goldwiretech.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit



Robin Whitworth wrote:

> I'm having trouble inserting binary data into a column of
> type bytea using a dynamic INSERT. The trouble seems to be if the
> data contains the values 0x5C (ASCII backslash) or 0x27 (ASCII
> singlequote). When I bind the input values for these I'm using
> SQL_C_BINARY. Shouldn't the data just be passed straight through,
> without any evaluation? Is there something special I need to
> do to make this work (or is this a bug?)
>

Sounds like a bug.   You should be able to see exactly what is being
sent to the backend by using the driver's log feature.   Could you send
that logfile which shows the error.

Byron