Re: store image file in the database ?

Hi,
thanks for your response,

what a good tool that can be use for querying image ?

just to clarify your answer :

if let's say i receive an image file called B001.JPEG with 60 KB size we can do conversion to oracle format data type / BLOB and store the file into database.
how about the image size in the database, is it still 60 KB or could it be larger or smaller size ?

and ur second comment :
 we can't convert the image in the database back to the JPEG file, is that what u mean ?
CMIMW ;) TIA regards
 Herman

• Original Message ----- From: "paquette stephane" <stephane_paquette_at_yahoo.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 27, 2000 6:10 PM Subject: Re: store image file in the database ?

> Hi,
>
> You can use blob for the images, clob is for text.
> We're using both, blob for .gif and .jpg and clob for
> text.
>
> Yes, you can query the images with the proper tool.
>
> I do not think that you can change the format of an
> image stored in Oracle.
>
> --- Herman Susantio <Sherman_at_bcsis.com> a écrit : >
> hallo guys,
> >
> > anyone knows how to store JPEG file in a database ?
> > and in what datatype ?
> > BLOB ? CLOB ?
> >
> > can we do the query for the image ?
> >
> > and if the image is already in the database,
> > can we convert it into JPEG file ?
> >
> > thank you
> >
> > regards
> >
> >
> >
> >
> >
> >
> > --
> > Author: Herman Susantio
> > INET: Sherman_at_bcsis.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Get Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jul 27 2000 - 07:42:57 CDT