I've always avoided using blobs, and have recently been reconsidering (trying to improve performance by not having to baseencode) it.....
but now I'm back to not wanting to use blobs. I hope someone here can finally clear this up once and for all.....how and if to use blobs correctly. Thanks Bob :) On Wed, Jul 31, 2019 at 12:45 PM Bob Sneidar via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi all. > > Those familiar with storing file data in SQL blob columns please chime in > if you have any ideas. I have added a File Storage module to my SQL based > app. Mostly it works a peach, but every now and then I encounter a file > that generates some kind of error. I get "mySQL Server has gone away" when > I attempt to insert the file. I open the files for binary read so it's the > raw file data unadulterated when I insert it. > > The nature of the files are typically backup information from copiers, so > it's likely they contain encryption hashes. They may also contain other > data that mySQL does not like. Any ideas? Should I be encoding the data > somehow before inserting? > > Bob S > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
