Received: from mailbox.TECHONE.COM.AU (mailbox.techone.com.au [202.12.109.179]) by hub.org (8.8.8/8.7.5) with ESMTP id TAA02211 for ; Wed, 12 Aug 1998 19:51:23 -0400 (EDT) Received: by mailbox.techone.com.au with Internet Mail Service (5.0.1457.3) id ; Thu, 13 Aug 1998 09:55:01 +1000 Message-ID: <303829F7300FD21197220020AFA04D290B5F52@mailbox.techone.com.au> From: Paul Lisewski To: Bryan Brunton , "'pgsql-interfaces@postgresql.org'" , "'Byron Nikolaidis'" Subject: RE: [INTERFACES] '\' and varchar data type problem w/ MS Access a nd ODBC driver Date: Thu, 13 Aug 1998 09:54:59 +1000 X-Priority: 3 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.0.1457.3) Content-Type: text/plain I have also found this to be true. I initially thought it was a problem in the ODBC driver, but after investigating a little further, found that it actually was the backend. You can test this via psql. The existance of even a single '\' character will cause the data to be corrupted. It seems to take the next character and converts it to binary data of some sort. I have not found a workaround for this eg. '\\' does not convert to a single '\' Regards, Paul Lisewski > -----Original Message----- > From: Bryan Brunton [SMTP:bryan@flesherfab.com] > Sent: Thursday, 13 August 1998 9:04 > To: 'pgsql-interfaces@postgresql.org'; 'Byron Nikolaidis' > 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. > > > >