'How to extract "Image" type from SQL Server Northwind database with JDBC

I'm unit testing binary data in a sample database and I want to read the image column from the Categories table from northwind sample db and save it to a file.

https://github.com/microsoft/sql-server-samples

I get the byte array fine but if I write it the image file is invalid. I've read that the format contains an OLE header 78 bytes to remove. I tried that but still the image is not viewable when I save it to a file. I tried saving as JBP and BMP. Neither worked.

Any ideas?

javasql-serverjdbcnorthwind


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions