Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver - Mailing list pgsql-interfaces

From James Oden
Subject Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
Date
Msg-id 010801bdc6b1$e40cd840$01cc0cac@Yehudah.lee.k12.nc.us
Whole thread Raw
List 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




pgsql-interfaces by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver
Next
From: Bryan Brunton
Date:
Subject: List '\' behavior as a bug?