I'm trying to encrypt a column in my table using
EncryptWithPassPhrase( @PASSPHRASE, @COLUMNDATA)
My Question is, does PASSPHRASE have to be (at least ) as long as the column data Is there a problem if it is longer>
I'm only storing part of the results, and it looks like the # of characters I'm storing is the length of my passphrase.
Thanks,
Phil
Sql Server Encryption
JaBa
As you noticed, the passphrase length is not related to what you encrypt, but as for any password, the longer the password, the harder it is for someone to find it.
If you are going to encrypt a lot of data using a passphrase, you would probably want to choose a longer one - at least 16 characters - and make it contain a mix of uppercase, lowercase, and special characters.
Thanks
Laurentiu
Dan Lukinykh
My bad.
I was using: Convert( varchar, DecryptByPassPhrase( 'PassPhrase', ColumnName)) and only getting 50 characters back Column Name, which has 80-180 characters.
Unfortuantely, my pass phrase was 50 characters in length which made me wonder what the issue was. It is really that the default value for a varchar is 50, which is the determining factof.
Convert(varchar(250), DecryptByPassPhrase( 'Phrase','Column))
gives the correct answer.