This question isn't strictly DBI, but I wasn't sure where to ask. Is there a preferred way to encrypt data stored in a database? I'm developing an application that has higher security requirements than what I've done in the past and I want to make sure the data is safe. I know that MySQL has an AES encrypt function, and I know about the Crypt:: modules, but I'm not sure what is typically used as a key (eg, when multiple users need to see the same data), etc.
Any advice would really be appreciated. =) Thanks! --TWH
