putting binary data into a mySQL database

Kay C Lan lan.kc.macmail at gmail.com
Thu Jan 21 06:30:09 EST 2016

Look up revExecuteSQL in the Dictionary. Of particular interest:

To pass binary data in a variable in the variablesList, prepend "*b" to the
> variable name. The *revExecuteSQL* command strips the binary marker "*b"
> and passes it to the database as binary data, rather than text data.

Basically you need to be using the variable list form of revExecuteSQL
rather than passing the data directly. Also there is a note about binary in
arrays that are being loaded into dbs.

More information about the Use-livecode mailing list