Hi to all,

I am using Java version 1.3 with IBM Websphere and DB2. I would like to create a page that you can save and retrieve an image from DB2 and post it on a web page using a stored procedure. My questions are:

1. How should I create the database table. Using varchar?
2. Since the stored procedure will return a string of hexadecimal characters (representing the image), which tag should I use to display theses hex chars on the screen?
3. How should I go about saving a picture on a database table?

Thank you very much,

Francis

Save it in the table as binary and retrieve it as such using content type image/jpg.

Can you give an example on how to code this in a JSP file. I also want to add other HTML content (i.e. tables, other texts)