NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on June 20, 2017, 11:19:59 PM

Title: Signature field type in MSSQL
Post by: terryd on June 20, 2017, 11:19:59 PM

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?

Title: Re: Signature field type in MSSQL
Post by: peterH on June 20, 2017, 11:25:06 PM

Hi Terry,

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

Peter

Title: Re: Signature field type in MSSQL
Post by: Bruce on June 21, 2017, 04:27:46 AM

Hi Terry,

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

cheers
Bruce