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 8DDBE9DC97F for ; Wed, 15 Mar 2006 07:13:48 -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 92034-08 for ; Wed, 15 Mar 2006 07:13:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 49F7B9DC8A5 for ; Wed, 15 Mar 2006 07:13:39 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id k2FB6nWn023942 for ; Wed, 15 Mar 2006 16:37:08 +0530 Received: from sandhyar (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id D4CEF33280C; Wed, 15 Mar 2006 16:17:37 +0530 (IST) Message-ID: <03ce01c6481f$7c228160$cd00000a@sandhyar> From: "sandhya" To: "Postgres" Cc: "sandhya" Subject: reg:FilePath error Date: Wed, 15 Mar 2006 16:28:41 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_03CB_01C6484D.85DAD2B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1506 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1506 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:33.89235 C:22 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.14 required=5 tests=[AWL=0.138, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.14 X-Spam-Level: X-Archive-Number: 200603/124 X-Sequence-Number: 20881 This is a multi-part message in MIME format. ------=_NextPart_000_03CB_01C6484D.85DAD2B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 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=20 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 ------=_NextPart_000_03CB_01C6484D.85DAD2B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi....
 
When i am trying to insert a string = data into=20 my table which has few escape sequence characters...The = entire=20 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=20
 
Where as the other Strings without these characters = are=20 getting inserted fine.How is this happening?How the Strings are getting = stored=20 into the Tables?
 
Bcoz of this \b,\n and \r characters..I am unable to = store my=20 data into the database and retrieve it.
 
Is there any Solution that we have?Or we need to = Take care of=20 these situations/cases?
 
Please give me your Suggestions to resolve this=20 issue..
Thank you very much..
Regards,
Sandhya R
 
=
------=_NextPart_000_03CB_01C6484D.85DAD2B0--