Re: How to store images?

Hi,

I think that Oracle8 LOB's datatype are better to store JPEG than RAW or LONG RAW.
LOB are more flexible.
You can store up to 4GB of binaries data, in a table or externally (BFILE), you can have more than one LOB per row, and other important features.

Have a look on Oracle 8 Application Developer's Guide.

Have a nice day.

Frederic DEBRUS a écrit dans le message <01bf042b$4ece21e0$3e35a99e_at_gal159a>...
>RAW is a variable length PL/SQL datatype and database column type that is
>used to store binary data or byte strings.
>RAW type declarations in database tables and PL/SQL require a range
>constraint that is limited to
> 32767 bytes for PL/SQL variables
> 255 bytes for database columns
>
>Related Conversion Functions:
>
>function hextoraw(str char) return raw;
>function hextoraw(str varchar2) return raw;
>function rawtohex(bin raw) return varchar2;
>
>
>Tom Smits <tom_at_avades.nl> wrote in article <37E77527.3928C863_at_avades.nl>...
>> Hi there,
>>
>> How can I store images in my Oracle8i database?
>> I'm a newbie and want to setup an e-commerce site
>> with 8i.
>>
>> But I don't know what kind of type I have to choose
>> for my JPEG's.
>>
>> Anyone,
>>
>> Thanx in advance,
>>
>>
>> Tom
>>
>>
>>
Received on Tue Sep 21 1999 - 08:07:10 CDT