Re: [SQL] Can I store bitmap graphics in a table?

On Mon, 20 Jul 1998, Dan Delaney wrote:

> Hello all, can a bitmap graphic file be stored into a table? If so,
> how? What field type should I set up in the table and how do I
> insert the graphic file?
> Thanks.
> --Dan

You need to use large objects.

Currently you use the oid type to store a large object's oid in a table.
Then using the lo_ functions to store and retrieve the image.

The easiest thing to do is look at the docs, although you may want to look
at the ImageViewer example in the JDBC driver (src/interfaces/jdbc/examples)
as it does this exact thing.

--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)uk