Encryption in sql server 2005

• Sam77

  Right there with Babe

  Points: 768

  More actions

  January 16, 2008 at 2:42 pm

  #182074

  I am trying to encrypt more 30 chars of plaintext with TRIPLE_AES, but SQL

  gives me errors or autmatically truncates my ciphertext/plaintext to 30

  plaintext characters.

  This particular SQL Statement .

  UPDATE tblDB

  SET ConnectionString = EncryptByKey(Key_guid('EncyptKey'),('Example

  connection string 33333333333333333333'))

  WHERE Label = @varLabel

  The 30 character result I get is:

  select * from tblDB

  Result - '"Example connection string 33"

  Does anyone have some suggestions? Thanks,

  Prem

• Sam77

  Right there with Babe

  Points: 768

  More actions

  January 17, 2008 at 2:24 pm

  #769453

  CONNECTIONSTRING DATATYPE IS VARBINARY(500)

  ANY HELP IS APPRECIATED ?

• Sam77

  Right there with Babe

  Points: 768

  More actions

  January 17, 2008 at 10:18 pm

  #769549

  I found the solution

  select convert(varchar(400), decryptbykey(fieldname)) from tblname. Thanks,