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