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..
– rLinhares