From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Paul Lisewski <paull@techone.com.au>
Cc: Bryan Brunton <bryan@flesherfab.com>
Cc: 'pgsql-interfaces@postgresql.org' <pgsql-interfaces@postgreSQL.org>
Cc: 'Byron Nikolaidis' <byronn@insightdist.com>
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver
Date: Thu, 13 Aug 1998 02:38:04 +0000
Message-ID: <35D2518C.EBF8ECFD@alumni.caltech.edu> (raw)
References: <303829F7300FD21197220020AFA04D290B5F52@mailbox.techone.com.au>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: lockhart@alumni.caltech.edu, paull@techone.com.au, bryan@flesherfab.com, byronn@insightdist.com
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver
In-Reply-To: <35D2518C.EBF8ECFD@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox