Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver

From: "James Oden" <joden(at)lee(dot)k12(dot)nc(dot)us>
To: "Bryan Brunton" <bryan(at)flesherfab(dot)com>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
Date: 1998-08-13 11:46:51
Message-ID: 010801bdc6b1$e40cd840$01cc0cac@Yehudah.lee.k12.nc.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bryan Brunton 1998-08-13 14:32:03 List '\' behavior as a bug?
Previous Message Thomas G. Lockhart 1998-08-13 02:38:04 Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver