Minimum datatype required for encryption of SQL Server 2014 column using AES_256

• SSRS Newbie

  Hall of Fame

  Points: 3244

  More actions

  July 15, 2015 at 9:29 am

  #305873

  Hello All,

  I've implemented column level encryption in SQL server 2014 using AES_256 algorithm. However, I had to change the dataype of the column to nvarchar(max). What is the minimum size/datatype reuired for a column to be encrypted using AES_256 algorithm in SQL server 2014?

  Thanks

• SSRS Newbie

  Hall of Fame

  Points: 3244

  More actions

  July 15, 2015 at 11:51 am

  #1812752

  Any help/suggestions is greatly appreciated. Thanks.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 15, 2015 at 12:43 pm

  #1812763

  Based on the example in this BOL Article, I'd say varbinary(128).

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question