Hi! -----Original Message----- From: Ragnar Hafstað [mailto:gnari@xxxxxxxxx] >are you sure your problem is with pg_crypto ? >what does this produce: > select bytea2text('Tübingen'::bytea) as foo; >? Well I'm sure it's not WITH pgcrypto but with actually using pgcrypto in conjunction with UTF-8 encoded text. This function doesn't do anything but replace a bytea::text-cast. >have you tried to use encode()/decode() instead ? >untested: > select > decode( > decrypt( > encrypt( > encode('Tübingen','escape') , > 'mypassphrase'::bytea, > 'bf'::text > ), > 'mypassphrase'::bytea, > 'bf'::text > ) > ) as foo; Yes, and that doesn't work either: mypgdb=# select decode(encode('Tübingen'::text::bytea,'escape'),'escape'); decode ----------------- T\303\274bingen (1 row) But I just found the bugger - we both confused encode and decode :) mypgdb=# select encode(decode('Tübingen','escape'),'escape'); encode ---------- Tübingen (1 row) Now using pgcrypto works, too: mypgdb=# select encode(decrypt(encrypt(decode('Tübingen'::text,'escape'),'mypassphrase','bf'),'mypassphrase','bf'),'escape'); encode ---------- Tübingen (1 row) Thanks nevertheless, this was exactly the push in the right direction that I needed! Kind regards Markus ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
