Re: BLOB, LONG, LONG RAW etc.
Date: Tue, 12 Mar 2002 02:15:32 GMT
Message-ID: <8xdj8.20123$702.10584_at_sccrnsc02>
For the manuals go to otn.oracle.com and click on documentation. You will have to sign up for otn, but it is free.
long's are character data. Long raws are binary data. Longs and Long raw
are deprecated - don't use them. Use LOBs instead.
clobs are character data. Blobs are binary data. Bfiles are external files.
Jim
"DL" <donlcs_at_yahoo.com> wrote in message
news:604bb90c.0203111005.7828b166_at_posting.google.com...
> Hi,
>
> I don't have any Oracle reference book, so, I have to make some
> assumptions here,
> q1: can multimedia file such as image, video, sound or documents like
> Word file, PDF file, be stored in either BLOB or LONG or LONG RAW, or
> ... column? I know BLOB is for sure, but don't know the definition of
> LONG and LONG RAW datatype.
> q2: and if q1 is clear, that is, these type of files may be stored or
> pointed to any one of the above-mentioned datatypes, which datatype
> would be most efficient DML-wise, and logically would most DBA and/or
> developer use that type for their work?
>
> Thanks.
>
> DL
Received on Tue Mar 12 2002 - 03:15:32 CET