Re: pgcrypto/encrypt insertion failes due to \\ (2 slah being - Mailing list pgsql-general

From Bruce Momjian
Subject Re: pgcrypto/encrypt insertion failes due to \\ (2 slah being
Date
Msg-id 200408152054.i7FKsC316915@candle.pha.pa.us
Whole thread Raw
In response to pgcrypto/encrypt insertion failes due to \\ (2 slah being next to each other)  ("Ismail Seyfi" <ismail.seyfi@vivakos.com>)
List pgsql-general
Ismail Seyfi wrote:
> Hi,
>
>
>
> I am currently using pgcrypto functions (encrypt(), decrypt()) on postgresql
> 7.4.1. There seems to be a problem when ever I try to insert a string that
> contains "\\" (2 slashes next to each other"). it gives an error message
> saying that it is not a valid entry for type bytea. I am using rijndael as
> the algrothim.
>
>
>
> Can any one tell me why this would be happening? Thanks for your time

I think with bytea you have to use extra slashes, perhaps "\\\\" for
every literal slash.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: case insensitive search with greek characters
Next
From: Bruce Momjian
Date:
Subject: Re: /contrib binaries for win32