Is it possible to encrypt an integer column ?

• onlo

  SSCertifiable

  Points: 5080

  More actions

  June 23, 2008 at 3:30 am

  #189475

  The official Microsoft Web site of the "EncryptByKey (Transact-SQL)" says its @cleartext only supports nvarchar, char, varchar, nchar, binary, varbinary.

  So, does it mean other than these data types, EncryptByKey doesn't support ? eg. int, ntext, decimal, datetime ?

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  June 23, 2008 at 4:18 am

  #832540

  [font="Verdana"]I hope it will encrypt numeric also!

  You can also try "Encryption & Decryption" article.[/font]

  Regards..Vidhya Sagar
  SQL-Articles