>Hi all,
>I'm experimenting with encryption using the VFPEncryption71.fll. It seems to work well, but I don't know how to pass the encrypted string to SQL Server. I created a VARBINARY field for this but don't know the syntax for the UPDATE or INSERT.
>
>UPDATE SomeTable SET EncField = BinaryGobbledygook WHERE PK = 123
>Fails with error "Incorrect syntax near..."
>
>UPDATE SomeTable SET EncField = 'BinaryGobbledygook' WHERE PK = 123
>Fails with error "Disallowed implicit conversion..." because of embedded quotes.
>
>Anyone succeed with this or perhaps I need a different way to store encrypted data.
>
>Thanks.
>
>GaryOne way to deal with embedded chars that confuse systems (generally with low-level ASCII chars for example), is to convert to BASE64.
See STRCONV() with parameters 13 and 14
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/e2b743ac-dec7-43ae-82db-ba6fa1e2cbd9.asp