Encrypting data

[tomp]

Is there a way to encrypt certain fields (e.g., credit card info) in a database, and then display them normally when appropriate?

[Vaughan]

There are third party plug-ins that can encrypt and decrypt data. A custom function may also be able to do it.

What kind of security are you looking for?

[tomp]

My clients can optionally store their customers' credit card data in the database. Card processors don't like that unless the data are encrypted. I was wondering what I could offer them