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!
Received on Thu Jul 27 2000 - 04:01:26 CDT
