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?