Post reply

Encryption: column size

  • January 9, 2010 at 11:19 am

    #229013

    Hi,

    I have a table to store user sensitive data.

    ...

    CMS_UserName VarChar(25) Unique Not Null Check(SomeChecks)

    ...

    25 characters for the user name is acceptable in my personal opinion.

    I chose to encrypt the data with a symmetric key which is protected by a password.

    25 characters isn't enough to store the encrypted data. I have randomly increased it to 250 and it worked.

    Fact that it works isn't good enough for me and I would like to find out if there is a simple way to determine require column length without doing too much analysis?

    Encryption algorithm used is AES_128, not sure if this is of any help.

    Thank you.

  • January 9, 2010 at 11:29 am

    #1101417

    Also, while we are here...

    Script to insert the encrypted data

    Open Symmetric Key ....

    Insert Statement

    Close Symmetric Key

    The script runs fine even when I don't close the symmetric key. What's the purpose in closing the key? I know how transactions work and connections, when you don't close connection you are wasting the resources. But how do the keys work? What happens when I open/close it?

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply