store a file in a BLOB / LONGBLOB(MySQL)

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

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
Top
MaxV
Posts: 1579
Joined: Tue May 28, 2013 2:20 pm
Location: Italy
Contact:
Contact MaxV

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
Top
Post Reply

Return to “Databases”