Blob Data in SQL/Server

[Grant MacDonald]

Hi folks.  We have a Microsoft Access application that we are migrating to a web based application with node.js on the backend.  There are a few Blob fields in the backend SQL/Server database that can be either PDF, JPG, MSG, etc. format.  We are trying to figure out the best way to handle the blob data:

1) Do you convert the blob to a file on the server (node.js) side and send the URL of this file to the client?  

2) Or...send the blob data to the client and let the client handle the formatting?  (the .MSG format is a bit of a challenge as it is supposed to open Outlook when they click on it)

3) For storing these files as blobs in the database, I presume we use something like formidable to read the data and then store it in the database blob field.

Any help or examples appreciated. 

Thanks. Grant. 

[John Kavanagh]

you just need to send the correct file-type header with the blob data

[Grant MacDonald]

Will that work for a .MSG file?

Thanks.