BLOB Storage Errors

Tom Glod tom at makeshyft.com
Wed Jul 31 13:41:26 EDT 2019


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
>



More information about the Use-livecode mailing list