>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. > >Gary
One way to deal with embedded chars that confuse systems (generally with low-level ASCII chars for example), is to convert to BASE64.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry