Subject data encryption
Author Mitchell Peek
I proposed this question as a reply to an old thread, throught it might
have been lost due to the age of the thread, so decided to re-intorduce
it in its own. Sorry for the redundancy...

someone suggested:

>You may need to store things like credit card numbers or passwords in
>the database. DBAs have full access to the database, and may need it,
>but you don't want them to know this information. If you need to get
>the information back out, then use encryption (blowfish etc) and store
>the encrypted data only.

Any suggestions on the best means of implementing encryption (any, not necessarily blowfish) of this sort? UDF? trigger? etc? How does one go about implementing such a thing and making this workable?

Mitchell Peek

[Non-text portions of this message have been removed]