471,347 Members | 1,740 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,347 software developers and data experts.

The business way to store personal data in database (any)

Hello,

What is the current modern way to store private information such as credit
card, social insurrance etc... into the database. There are standards that we
have to request like FIPS.

I could use AES with 256bit keysize length, but the secret key should be
exactly 7 characters long. If I do less than 7 or greater than 7 characters,
it states invalid AES key length.

Is that the best way to crypt those types of data in the database? Or what
is the better way to encrypt/decrypt those private data?

Any information would help! I am kinda new to this process.

Apr 8 '08 #1
1 1330
On Apr 8, 11:33*am, m0 <m...@discussions.microsoft.comwrote:
Hello,

What is the current modern way to store private information such as credit
card, social insurrance etc... into the database. There are standards thatwe
have to request like FIPS.

I could use AES with 256bit keysize length, but the secret key should be
exactly 7 characters long. If I do less than 7 or greater than 7 characters,
it states invalid AES key length.

Is that the best way to crypt those types of data in the database? Or what
is the better way to encrypt/decrypt those private data?

Any information would help! I am kinda new to this process.
Hi,

I think that it depends in part of the DB server you are using, how
are you accessing the data and from where.
SQL 2005 has some encription features already in place.

In case that you are using it (sql 2005) you should ask this question
in the sqlserver.* NG
Apr 8 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Hasan O. Zavalsiz | last post: by
5 posts views Thread by G. Stewart | last post: by
16 posts views Thread by MS newsgroup | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.