RE: store image file in the database ?

You can convert images stored in Oracle database into the file system formats that oracle supports. I do not have documentation right now, to = give
you the details. But you can
Aleem

 -----Original Message-----

From: 	Herman Susantio [mailto:Sherman_at_bcsis.com]=20
Sent:	27 July 2000 18:57
To:	Multiple recipients of list ORACLE-L
Subject:	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 ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 27, 2000 6:10 PM

> 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 =E9crit : >
> 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
> >
> >
> >
> >
> >
> >
Received on Thu Jul 27 2000 - 08:31:08 CDT