best way to store data from signature widget into mysql db

Ralph DiMola rdimola at
Tue Aug 13 15:39:03 EDT 2019

If everything is in an array then "arrayEncode" the array and store it in a db. Then arrayDecode it when retrieving it from the DB. You may also have to base64Encode/base64Decode to eliminate any binary.

Ex: (not tested)
Put Base64Encode(arrayEncode(sigArray)) into DBdata
Put arrayDecode(Base64Decode(DBdata)) into sigArray

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at] On Behalf Of JJS via use-livecode
Sent: Tuesday, August 13, 2019 3:23 PM
To: How to use LiveCode
Subject: best way to store data from signature widget into mysql db


i was wondering what the best way would be to store a signature of the signature widget into mysql db, so i can recall it.

1. figure out how many keys/elements there are in the array, as  it will be different per signature (serialize it as a single string, or create a JSON and store it directly)


2. is it possible to export the signature, which probably is an svg, to an jpg/png so i can store it as BLOB?

thanks for any insights.



use-livecode mailing list
use-livecode at
Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the Use-livecode mailing list