Обсуждение: '\' 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.

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