Thanks, that helped. This is what we did: (to encode VARCHAR -> BYTEA) update webuser set ccnum = decode(ccnumstring, 'escape') where userid=userid
(to decode BYTEA -> VARCHAR) select encode(ccnum, 'escape') from webuser But what about decrypting with the AES encryption algorithm? Dylan -----Original Message----- From: Ian Barwick [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 2:36 PM To: Dylan Milks; PostgreSQL (E-mail) Subject: Re: [ADMIN] Casting varchar to bytea On Friday 12 September 2003 20:39, Dylan Milks wrote: > Hi. Could someone please tell me how to convert a "varchar" to a "bytea" > datatype. > > I have a column which contains a number stored as a varchar. I have another > column of type bytea. I'm trying to insert the value of the varchar column > in the bytea column, but the conversion won't work. > > Something like the following: > > update webuser set ccnum = ccnumstring::bytea where userid=userid; > > Any ideas how to do this? Does update webuser set ccnum = decode(ccnumstring::text, 'encode') work? Ian Barwick [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
