asked
Data in certain fields in a table needs to be encrypted and later on decrypted to be used in sp. What should be the appropriate data type that can be used so that the same column can hold both the encrypted form and decrypted form of data?
The requirement is that the data in certain columns need to be encrypted after data is loaded and later on need to be decrypted so that these values can be used in calculations in a stored proc. My questions are :- Do I add new columns to the existing table to hold encrypted data in varbinary or something? What can be the appropriate data type that can hold both the encrypted value and the value after decryption in the same column?
Also please suggest how can I approach this problem of encryption ?? Do i move out these fields in separate tables? Will it help me in any way ?? I will be grateful if I can get some quick suggestions on this?
you may also wish to combine this question with your original question in the form of a comment.
please post this question in the default section and not the meta-askssc section.
If you're going to encrypt individual columns (not something I've done personally), I've always seen it done as binary storage.
16 People are following this question.
