SQL UPDATE with binary data

N

Nigel Findlater

Hallo

I have a table with Text fields. I would like to encrypt these fields and save them to the database. The problem is the encryption produces binary characters that destroy the SQL statement. Below is an example of the sql that I am using where xxx are binary characters

UPDATE Test Set Test.Name='xxx

How can I biuld an SQL UPDATE statement with binary characters

Nigel...
 
Top