Hi,

I am inserting spanish words using encrypt function in the table. when I fetch the using decrypt function. Value is not properly decrypted.

insert into emp (last_name) values (encode(encrypt('Rodríguez' ,'11'::bytea,'bf'::varchar),'hex'));

select bytea2text(decrypt(decode(last_name, 'hex'),'11'::bytea,'bf')) from emp;

Can you please help me how to decrypt correct spanish words ?

Regards,
Tushar