Обсуждение: Can I store bitmap graphics in a table?
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
-----------------------------------------------------------------------
Daniel G. Delaney The Louisville Times Chorus
Dionysos@Dionysia.org www.LouisvilleTimes.org
www.Dionysia.org/~dionysos/ Dionysia Design
ICQ Number: 8171285 www.Dionysia.com/design/
-----------------------------------------------------------------------
I doubt, therefore I might be.
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@retep.org.uk or petermount@earthling.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@maidstone.gov.uk