Inserting Binary Data into SQL Database Using KNIME

[mlauber71]

@SnigdhaBiswas you might have to configure the type of he column in the DB write/Insert node as BLOB.

Python Script - export images in table

@ActionAndi what you can do is store the PNG file in a SQLite database and then read it back into KNIME. [image] Just make sure that you have an actual PNG file (binary) and store it as a BLOB data type in SQLite. If you read it back to KNIME make sure the column “data” with the image is defined as a PNG file: [image] You might be able to combine these approaches: You can extract the current surroundings from a node. I have also created a component for that:

You will have to have the data as column type binary in your knime workflow. The column will have to match the ones in the database table you want to write to

Files to Binary Objects