SQL Server error in UPDATE column with Always Encrypted

Asked

Viewed 12 times

0

I’m implementing in a bank SQL Server the Always Encrypted which serves to encrypt columns of a table.

The process of creating the certificate, link it in a table/cokuna and use it in the SQL Server Management Studio is okay.

Problem

While trying to make UPDATE in the column that was encrypted, error is occurring.

SQL

update CLIENTE set CL_CGCCPF = '11111111111*' where CL_ENCODIGO = 34

Error

Msg 206, Level 16, State 2, Line 1 Operand type Clash: varchar is incompatible with varchar(8000) Encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'Certificadoteste', column_encryption_key_database_name = 'LGPD') collation_name = 'Sql_latin1_general_cp1_ci_ai'

  • https://stackoverflow.com/a/41067249/4551469 might help..

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.