Re: More questions on storing images in oracle

From: Roderick Manalac <rmanalac_at_oracle.COM>
Date: Tue, 16 Feb 1993 05:24:52 GMT
Message-ID: <1993Feb16.052452.9582_at_oracle.us.oracle.com>


Neil Greene <neil_at_kynug.org> writes:
|> I was wondering what conversion process actually occurs to an image (long
|> raw) when it is stored inside the oracle database?? Looking in the
|> manuals there is reference to data being converted to hex. Could someone
|> give more details?? What about a compressed image?? Would the image be
|> stored in its compressed format, or would the image be uncompressed??

Oracle does not really do any conversion of RAW and LONG RAW data. If you "INSERT INTO t (raw_column) VALUES ('7D');" then what is stored in the database is the binary representation of hex('7D') with each pair if hexadecimal digits taking up one byte [in the above statement there is an implicit hextoraw() conversion done on the string]. It's up to the application to figure out how it wants to store the data representing an image. The compressing and uncompressing of that data would also be up to the front-end application.

Roderick Manalac
Oracle Corporation
Worldwide Support

[DISCLAIMER: The opinions expressed are mine] Received on Tue Feb 16 1993 - 06:24:52 CET

Original text of this message