I have a SQL Table which holds document data in the form of type image (or possibly binary but as far as I can see image is more reliable).
I have a websewrvice which needs to pull the documents from the database, pass the details into an XML file which is retrieved by the application calling the webservice, and then the document files written out at the other end.
My question is what is the best way to go about this?
I believe (but possibly I am wrong) that I need to convert the image data to base64 first. I know there is the sql command select X from A FOR XML AUTO, BINARY BASE64 which does the conversion but I am not sure how to then write this into an XML document.
Any assistance any one can offer is greatly appreciated as I have not had any experience with working with binary or image, and only very very basic knowledge of XML
View Complete Post