I see that's how you cast...Yes that worked PERFECTLY. I am always learning something new from the list. Thank you VERY much!
-----Original Message----- From: Richard Huxton [mailto:d...@archonet.com] Sent: Tuesday, November 17, 2009 2:07 PM To: Naoko Reeves Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] does encrypt function support higher than basic ascii? Naoko Reeves wrote: > Sorry, as Richard said the issue was me not converting bytea to text. The > blow did it . thank you! > > SELECT convert_from((select decrypt(encrypt((select convert('aéiou','LATIN1', > 'LATIN1')),'foo','aes'),'foo','aes')),'UNICODE') I'm surprised you can't just do: SELECT convert_from( decrypt( encrypt( 'aéiou'::bytea, 'foo', 'aes' ) , 'foo', 'aes' ) , 'unicode' ) You should be able to cast to bytea simply enough. Coming back the other way, you do need to tell it what encoding you have through convert_from(). -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general