Re: [INTERFACES] ODBC & bytea - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] ODBC & bytea
Date
Msg-id 37711BFE.1E6EEA3C@solipsys.com
Whole thread Raw
In response to ODBC & bytea  (Robin Whitworth <rwhit@goldwiretech.com>)
List pgsql-interfaces

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




pgsql-interfaces by date:

Previous
From: "Collin F. Lynch"
Date:
Subject: ARC/Info and Intergraph
Next
From: "Jon Nielsen"
Date:
Subject: RE: PG6.5 + JDBC + Linux + Kaffe