Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <35D2518C.EBF8ECFD@alumni.caltech.edu>
Date: Thu, 13 Aug 1998 02:38:04 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
MIME-Version: 1.0
To: Paul Lisewski <paull@techone.com.au>
CC: Bryan Brunton <bryan@flesherfab.com>,
	"'pgsql-interfaces@postgresql.org'" <pgsql-interfaces@postgreSQL.org>,
	"'Byron Nikolaidis'" <byronn@insightdist.com>
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a
	nd ODBC driver
References: <303829F7300FD21197220020AFA04D290B5F52@mailbox.techone.com.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> You can test this via psql.
> The existance of even a single '\' character will cause the data to be
> corrupted. It seems to take the next character and converts it to 
> binary data of some sort. I have not found a workaround for this eg. 
> '\\' does not convert to a single '\'

tgl=> create table tx (v varchar(20));
CREATE
tgl=> insert into tx values ('123\'456');
tgl=> insert into tx values ('123\\456');
tgl=> select * from tx;
v
--------
123'456
123\\456
(2 rows)

One "problem" with the backend is it escapes characters on both input
_and_ output, which has always struck me as at least partially defeating
the usefulness of escaping input.

As you notice in the above example, it does not escape all characters on
output, but only a few. But I don't know where you see binary data!?
What version are you running?

                       - Tom