According to this site:
https://www.devart.com/sdac/docs/?encryption.htm
I'm trying to setup encryption for one column of my table.
I've setup a varbinary(200) column but when i try something like this:
Code: Select all
qry.CommandText := 'update mytab set encryptionfield = :field where ID = 1'
qry.Encryption.Encryptor := MSEncryptor;
qry.Encryption.Fields := 'encryptionfield';
qry.Password := '11111';
qryDataTypeMap.AddFieldNameRule ('encryptionfield', ftString);
qry.Parameters.ParamByName('field').AsString := 'Do something';
qry.Execute;
...
Can not convert nvarchar in varbinary