Thread: pgcrypto/encrypt insertion failes due to \\ (2 slah being next to each other)
pgcrypto/encrypt insertion failes due to \\ (2 slah being next to each other)
From
"Ismail Seyfi"
Date:
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
Thanks
Ismail
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