store a file in a BLOB / LONGBLOB(MySQL)

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
jlspereira
Posts: 18
Joined: Sat Mar 01, 2014 10:35 pm

store a file in a BLOB / LONGBLOB(MySQL)

Post by jlspereira » Fri Jan 29, 2016 11:29 pm

Hi

I am implementing a database application in livecode and I need to sore, in the database, som "special" files that are later to be retrieved to be either downloaded of, in some case, viewed.
The files, themselves will be in standard formats, mostly images / PDF / MP3 / videos (short ones).

how do I do it?

kind regards for all help

MaxV
Posts: 1574
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:

Re: store a file in a BLOB / LONGBLOB(MySQL)

Post by MaxV » Tue Feb 02, 2016 4:59 pm

BLOB is the right format, see the second part of this page for working with binaries: http://livecode.wikia.com/wiki/SQLite
Livecode Wiki: http://livecode.wikia.com
My blog: https://livecode-blogger.blogspot.com
To post code use this: http://tinyurl.com/ogp6d5w

Post Reply

Return to “Databases”