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: BLOB vs LONG RAW

Re: BLOB vs LONG RAW

From: Richard Armstrong <richard.armstrong_at_juno.demon.co.uk>
Date: Sun, 26 Nov 2000 13:10:09 -0000
Message-ID: <975244267.18315.0.nnrp-09.9e9809ca@news.demon.co.uk>

I read somewhere that Oracle don't guarantee to support LONG data types in future releases of the database. It might be better to go with LOBs.

Regards,

Richard

<jpickup_at_my-deja.com> wrote in message news:8vlpq8$v83$1_at_nnrp1.deja.com...
> When using an Oracle 8i database, which datatype should I be using for
> storing binary data? In the past I've always used LONG RAW but see that
> there is now a BLOB type.
>
> I've written some code to use the BLOB and it was rather different (the
> LOB Locator stuff is RETURNING keyword is pretty weird). At this stage
> LONG RAW is looking better as it seems more straight-forward to use.
>
> A quick summary of pros and cons of the two types would be great...
>
> Thanks,
> John.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Nov 26 2000 - 07:10:09 CST

Original text of this message

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