From: James Oden <joden@lee.k12.nc.us>
To: Bryan Brunton <bryan@flesherfab.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
Date: Thu, 13 Aug 1998 07:46:51 -0400
Message-ID: <010801bdc6b1$e40cd840$01cc0cac@Yehudah.lee.k12.nc.us> (raw)
>
>The backslash character '\' seems to cause problems when using the
>varchar
>data type. MS Access will refuse to update a varchar field if 3
>backslashes
>have been inserted.
If you want litterally three backslashes you may need to massage the data to
add an extra one before each one, so your three back slashes become six back
slashes. I am just guessing on this, but in postgreSQL's implementation of
SQL (and this may be just a SQL thing) the \ is used as an escape sequence,
much like it is in C. Someone else on the list earlier had a problem
recreating his databases from a dump because it did have \'s in it....james
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: joden@lee.k12.nc.us, bryan@flesherfab.com
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
In-Reply-To: <010801bdc6b1$e40cd840$01cc0cac@Yehudah.lee.k12.nc.us>
* 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