🚀 go-pugleaf

John A. Simpson wrote:
> I need some code or information on how to store JPEG graphic files in a SQL
> Server database.  Any help would be greatly appreciated.

It depends on how you access the DBS. The IMAGE datatype stores
"something
binary" and does not determine the file format.
There are ways to use an INSERT to insert the binary data with a string
and SELECT returns an amount of binary data.
In JDBC/ODBC the type TEXT is handled with Sting types, which are
interpreted as being binary data too (according to Transact SQL). Try to
insert data by giving a String type which contains the raw data. Vice
versa,
try to fetch the image data into a String. Use stored procedures to
encapsulate the transaction? (How to cast a String to an image container
is yet another problem...and depends on your access method.)
(For hints on MS Acces read the other replies.)
In the near future we are going to have these problems using JBBC/ODBC
to store GIF/JPEG images in MS SQL-Server 6.5 (these formats, since
Java supports them).

I'll keep your question in mind.

Greetings,
Andreas.

-- 
Andreas Pohlke                               Siemens AG, PN GS 375
Andreas.Pohlke@pn-msmail.bln.siemens.net     Berlin S
Intranet: http://198.7.1.105                 Tel: (+49 30) 386 27610
"Der Daten sind genug gewechselt - nun lasst Informationen folgen!"
--
Andreas Pohlke                               Free University of Berlin
pohlke@inf.fu-berlin.de                      Insitute of Computer
Sciences
http://www.inf.fu-berlin.de/~pohlke          Berlin, Germany
"Superstition brings bad luck"