locked
Is it possible to encrypt varbinary(max) column using Always Encrypted feature? RRS feed

  • Question

  • We are implementing the Always Encrypted encryption feature for our application database.

    There is a table with varbinary(max) column storing binary data of images, pdf document etc.

    Is the Always Encrypted feature supports varbinary(max) column encryption? if yes, how to do it using SQL Server 2016?

    Can anyone please support ?

    Tuesday, April 3, 2018 1:51 AM

All replies

  • I dont know definitive answer but quoting from This Blog

    SQL Server Management Studio can decrypt the results retrieved from encrypted columns if you connect with the column encryption setting=enabled in the Additional Properties tab of the Connect to Server dialog, except encrypted varbinary(max), nvarchar(max) andvarchar(max) values. SQL Server Management Studio does not support inserting, updating, or filtering encrypted columns.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, April 3, 2018 4:32 AM