question

jodman avatar image
jodman asked

Why doesn't the data type of my encrypted columns change with always encrypted?

I am starting to take an in-depth look at always encrypted and have been working through some examples.

I have a column which is an integer and i have selected that column for always encrypted encryption.

When i query this column, the encrypted data is returned (not an integer) but the data type of the column remains INT. Why is this? I expected that it would have been converted to a varbinary.

Thanks.

always-ecnryptedalways encrypted
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.