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

From kataoka@interwiz.koganei.tokyo.jp (Hiroki Kataoka)
Subject Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
Date
Msg-id 19980813111633Q.kataoka@interwiz.koganei.tokyo.jp
Whole thread Raw
In response to '\' and varchar data type problem w/ MS Access and ODBC driver  (Bryan Brunton <bryan@flesherfab.com>)
List pgsql-interfaces
Hello all,

From: Bryan Brunton <bryan@flesherfab.com>
Subject: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver

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

The following is a patch of correcting this '\' problem for PostgreSQL
ODBC Driver. I have already applied this patch, and no problem happened.

Hiroki Kataoka <kataoka@interwiz.koganei.tokyo.jp>

######## cut here ########
*** convert.c.orig    Thu Aug 13 10:58:25 1998
--- convert.c    Thu Aug 13 10:59:43 1998
***************
*** 964,969 ****
--- 964,971 ----
              continue;
          if (si[i] == '\'')
              p[out++] = '\\';
+         else if (si[i] == '\\')
+             p[out++] = '\\';

          p[out++] = si[i];
      }
######## cut here ########

pgsql-interfaces by date:

Previous
From: Paul Lisewski
Date:
Subject: RE: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver