From: | Thusitha Kodikara <kthusi(at)yahoo(dot)com> |
---|---|
To: | sandhya <sandhyar(at)amiindia(dot)co(dot)in>, Postgres <pgsql-admin(at)postgresql(dot)org> |
Cc: | sandhya <sandhyar(at)amiindia(dot)co(dot)in> |
Subject: | Re: reg:FilePath error |
Date: | 2006-03-15 11:43:13 |
Message-ID: | 20060315114313.57432.qmail@web34409.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <sandhyar(at)amiindia(dot)co(dot)in> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2006-03-15 14:34:02 | Re: Wisconsin Circuit Court Access (WCCA) on |
Previous Message | sandhya | 2006-03-15 10:58:41 | reg:FilePath error |