Subscribe Bookmark RSS Feed

Blob variable crashes mySQL query with query builder.

morenopelaez_p

Community Trekker

Joined:

Feb 24, 2015

I have a database that contains small images in a blob variable. I have tried to query it with query builder but the whole query does not work (columns come up empty and the blob is not imported).

Can I import blobs with query builder or is this just not supported?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hi,

JMP does not support directly the import of BLOB objects with Query Builder at this time.  JMP ignores the BLOB object because it does not know how it should be interpreted.


Alternatively, you could do something similar as mentioned in this discussion Byte Array Image from Database to JMP

Thanks,

Stan

2 REPLIES
Solution

Hi,

JMP does not support directly the import of BLOB objects with Query Builder at this time.  JMP ignores the BLOB object because it does not know how it should be interpreted.


Alternatively, you could do something similar as mentioned in this discussion Byte Array Image from Database to JMP

Thanks,

Stan

morenopelaez_p

Community Trekker

Joined:

Feb 24, 2015

Thanks Stanley, very clear. I will investigate what we can do via the solution you referred to.

That said, it would be a great new feature to be able to download pictures from a DB as we can now do with "internet open".