Showing results for 
Search instead for 
Did you mean: 

BLOB database image conversion

Go to solution

I have a database which contains BLOB image data and need to convert this back to the original .jpg image.  I haven't been able to figure out how to do this and can't find any relevant posts discussing this.


I have attached an image of a retrieved BLOB from the database for reference.


Any help or pointing to an example resource would be really appreciated!



0 Kudos
Message 1 of 3
Accepted by topic author mblock

What happens if you use a Write to Binary File node to write this BLOB to disk with a filename with .jpg extension? Watch out on the at the Write to Binary File node, it has a boolean input "prepend array of string size (T)". You want to set this explicitly to false to prevent the Write to Binary File node to prepend an int32 to the data that indicates how many bytes follow.


Other that this suggestion there is nothing we can do for you with an image.

Rolf Kalbermatter
Averna BV
Message 2 of 3

Thank you rolfk you led me right to the solution!

0 Kudos
Message 3 of 3