Signature field type in MSSQL

[terryd]

We are using signatures in a Web application. If we use tps and set the field as a memo there is no problem.
What I would like to do is store the field in an MSSQL table. I have tried various data types Cstring, String and Blob but have had no luck in storing the data in these fields.
Is it possible, and if so, is there an example.
Should I bring it up during the Webinar tomorrow?

[peterH]

Hi Terry,

Try varbinary(max) - assuming the signature is stored as an image.

Peter

[Bruce]

Hi Terry,

as I recall the signature is saved as a large text string. So a VarChar should do it I think?

cheers
Bruce