reg:FilePath error

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "Postgres" <pgsql-admin(at)postgresql(dot)org>
Cc: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
Subject: reg:FilePath error
Date: 2006-03-15 10:58:41
Message-ID: 03ce01c6481f$7c228160$cd00000a@sandhyar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thusitha Kodikara 2006-03-15 11:43:13 Re: reg:FilePath error
Previous Message Simon Riggs 2006-03-15 10:41:23 Re: PITR as Online Backup Solution