Message-ID: <377103C7.D695CB9E@goldwiretech.com>
Date: Wed, 23 Jun 1999 11:56:55 -0400
From: Robin Whitworth <rwhit@goldwiretech.com>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: ODBC & bytea
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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?)

Platform: linux, x86
PostgreSQL version: 6.4.2 (installed from the linux RPM's)
ODBC driver: the one included with the 6.4.2 RPM's (I haven't
found the version of this clearly labelled anywhere).
	-rwhit

.........................................................
Robin Whitworth                 Gold Wire Technology Inc.
rwhit@goldwiretech.com          P.O. Box 103
617.876.9473x1603               Belmont, MA  02478-0001