Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.1/8.9.1) with ESMTP id RAA05342 for ; Mon, 11 Jan 1999 17:04:26 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id RAA10449; Mon, 11 Jan 1999 17:01:34 -0500 Message-ID: <015701be3daf$b0c11e90$8355e5ce@base2inc.com> From: "Frank Morton" To: "Joel Fischer" , Subject: Re: [SQL] storing strings with embedded '\' Date: Mon, 11 Jan 1999 17:13:57 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 This is a real pain. What I do is have a "cleanString" method that I pass everything through when constructing SQL statements that changes all '\' to '\\' and all seems to work just fine. Also note that pg_dump has a bug in this area that I am unable to get attention from anyone. In my setting, if I pass "\net" in the actual SQL it turns into "\\net" but when read as part of a select, it is "\net" as expected. However, pg_dump does not double-up the backslash, so it is unusable to psql. Anyone listening? ----- Original Message ----- From: Joel Fischer To: Sent: Monday, January 11, 1999 4:05 PM Subject: [SQL] storing strings with embedded '\' >Hello, interested in storing strings with embedded '\' characters? Using \\ >appears to store \\. Suggestions? > >Joel Fischer >Ascend COmmunications >