Re: does encrypt function support higher than basic ascii?

Naoko Reeves wrote:
> Hello,
>
> I have the following statement and accent e doesn't seems to be
> decrypted correctly.
>
> select decrypt(encrypt('aéiou','foo','aes'),'foo','aes')
>
> Could you tell me if there is an option for encoding or this function
> only encrypt basic ascii?

They take bytea rather than text and return bytea too.

Does casting the result give you valid text?

--
  Richard Huxton
  Archonet Ltd