Re: Storing JPG's as BLOB data type

[Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>]

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.