Re: Storing JPG's as BLOB data type

From a web page, you can do something like this:

<img src="examples/getImage.php?item=4014" />

So when the browser asks for the image, it actually calls (in this example) a PHP script. The PHP script uses SQL to retrieve the BLOB and return it. (It could also have additional logic that verified that the user was allowed to access the image.)

This example is PHP, but it doesn't have to be -- it could be RPG, Java, whatever you like...

Whatever the script is, it needs to set the content-type to image/jpeg (or whatever the image format is) and send the raw binary contents of the image as it's output (stdout).


On 7/6/2011 5:31 PM, Chris Bipes wrote:

We have to send the images via XML posts to third parties and they
require the Base64 encoding. But you are correct, when I do bite the
dust and store our images directly in the database; I most likely
will not save the converted image. My biggest concern and no one
here knows how, is how to display the images in a web page without
storing the image on publically accessible servers, and not allowing
the user to print/save the image to their local PC/MAC for security
reasons. For now we keep them on our NAS and only our mounted
servers have access.