Getting age from an encrypted DOB field

Posted by Mailforbiz on Stack Overflow See other posts from Stack Overflow or by Mailforbiz
Published on 2010-04-21T15:40:23Z Indexed on 2010/04/21 15:43 UTC
Read the original article Hit count: 170

Filed under:
|

Hi all

Due to certain compliance requirements, we have to encrypt the user DOB field in the database. We also have another requirement to be able to search a user by his age. Our DB doesn't support transparent encryption so encryption will handled by the application.

Any good ideas on how to allow for searching by age? One thought is to save the YOB in a separate column in cleartext and still be able to comply to our compliance requirement.

Aside from that, any other design strategy that would help?

Thanks in advance!

© Stack Overflow or respective owner

Related posts about encryption

Related posts about database