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

Hello all,

From: Bryan Brunton <bryan(at)flesherfab(dot)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(at)interwiz(dot)koganei(dot)tokyo(dot)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 ########