May 7, 2008 at 10:06 am
Hi,
Our company is planning to implement PCI and this requires storing sensitive data in an encrypted format. The algorithms that I have selected includes the following
1) DES ( Digital Encryption Standard) - 64 bit
2) RC2 - 128 bit
3) Triple DES - 192 bit
4) Rijndael - 256 bit
My question is how do I account the field size if i were to implement it. I know the encrypted data requires more space in the database. So for example if column A is of varchar(15) any idea what needs to be the size of the column if the column A was to be encrypted
Thanks
Vinoj
May 7, 2008 at 2:45 pm
If I'm not mistaken, the specifications for the encryption protocol will give you that information.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 7, 2008 at 3:15 pm
I think the size is slightly dependent on the data and the algorithm. Since a varchar(15) doesn't really take any more space than a varchar(55), why worry? Set the size to be large enough to hold whatever the largest size you expect.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply