X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0321E9DCC84 for ; Wed, 15 Mar 2006 07:49:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98843-05 for ; Wed, 15 Mar 2006 07:49:57 -0400 (AST) X-Greylist: delayed 00:06:40.649569 by SQLgrey- Received: from web34409.mail.mud.yahoo.com (web34409.mail.mud.yahoo.com [66.163.178.158]) by postgresql.org (Postfix) with SMTP id 99AEB9DCC15 for ; Wed, 15 Mar 2006 07:49:51 -0400 (AST) Received: (qmail 57434 invoked by uid 60001); 15 Mar 2006 11:43:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=pvhbCAObsW+W160mwCtpA86NMQxGHtV6HrWIZWeIQW7L7/wSYqmwx7DXYHAk2Isuxo0jEfODsWpf/rlRYJYgA+XVR+XE+E+LvtrX+rKJt9zct7mMxbdZW8wWPNeqx3NFZ5o6lKmzyUCaSlSFF/W/iZXozUNjEnNKKZkpFJIAzME= ; Message-ID: <20060315114313.57432.qmail@web34409.mail.mud.yahoo.com> Received: from [203.115.30.220] by web34409.mail.mud.yahoo.com via HTTP; Wed, 15 Mar 2006 03:43:13 PST Date: Wed, 15 Mar 2006 03:43:13 -0800 (PST) From: Thusitha Kodikara Subject: Re: reg:FilePath error To: sandhya , Postgres Cc: sandhya In-Reply-To: <03ce01c6481f$7c228160$cd00000a@sandhyar> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.358 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.358 X-Spam-Level: * X-Archive-Number: 200603/125 X-Sequence-Number: 20882 Hi Sandhya, Try using two "\" characters if you want to insert on "\". For example use "C:\\ProgramFiles\\SampleFiles\\General\\back.doc" \b, \r, \t ... have special meanings. Please refer http://www.postgresql.org/docs/8.1/static/functions-matching.html Regards, -Thusitha --- sandhya wrote: > Hi.... > > When i am trying to insert a string data into my > table which has few escape sequence characters...The > entire string is not getting inserted. > Like Ex: > If my String data is > > C:\ProgramFiles\SampleFiles\General\back.doc > > C:\ProgramFiles\SampleFiles\General\rback.gif > > C:\ProgramFiles\SampleFiles\General\nback.rar etc > like this. > > But in my table the string is getting stored as, > > C:ProgramFilesSampleFilesGeneraack.doc > > Where as the other Strings without these characters > are getting inserted fine.How is this happening?How > the Strings are getting stored into the Tables? > > Bcoz of this \b,\n and \r characters..I am unable to > store my data into the database and retrieve it. > > Is there any Solution that we have?Or we need to > Take care of these situations/cases? > > Please give me your Suggestions to resolve this > issue.. > Thank you very much.. > Regards, > Sandhya R >