Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited tags
Link
SEJPM
  • 46.4k
  • 9
  • 102
  • 210
Source Link
LP13
  • 111
  • 2

Encrypting/Decrypting sensitive information for storage purpose

I want to store account numbers and routing numbers into SQL database, and i was looking for best way to encrypt/decrypt this sensitive information. After researching i found i can use symmetric (like AES) or asymmetric (like RSA, X509 Certificate) algorithms. I just want to encrypt/decrypt the information locally on the server and store it into SQL DB. Is it recommend to use AES with 128 bit HEX key for such purpose?
Use of asymmetric algorithms seems to be overkill since encryption/decryption will happen locally on the same server.

(Note that this information will ultimately transfer to vendor using SFTP, however during that transfer we will be using vendor provided PGP public key for encryption so vendor can decrypt it. What i am looking here is encryption/decryption for local storage)