BLOB Storage Errors

[Tom Glod]

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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>