Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to store images?

Re: How to store images?

From: Frederic DEBRUS <frederic.debrus_at_ces-cdr.be>
Date: 21 Sep 1999 12:10:05 GMT
Message-ID: <01bf042b$4ece21e0$3e35a99e@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 - 07:10:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US