Thread: '\' 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.
Re: [INTERFACES] '\' and varchar data type problem w/ MS Access and ODBC driver
From
kataoka@interwiz.koganei.tokyo.jp (Hiroki Kataoka)
Date:
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 ########