Home

Always Encrypted column type

SkySky

i use linqpad 7 use Always Encrypted

my sample ↓
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-tutorial-getting-started?tabs=ssms&view=sql-server-ver16&viewFallbackFrom=azuresql

i get message
nvarchar(11) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'AA') 與 char(11) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'AA') collation_name = 'Chinese_Taiwan_Stroke_BIN2'

I found the reason which the SSN column Type is char(11),but linqpad execute is nvarchar(11)

· Share on FacebookShare on Twitter
Sign In or Register to comment.