Re: CLOB vs. BLOB

Ok there is a difference in in BLOB and CLOB

Blob stores unstructuresd Binary Data.
and CLOB store single byte Chatracter Data set . there is an other Data type NCLOB which store fixed-width and varrying -width multibyte national character set data.

Regards
Faheem Rao

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tte2rdnsdbuje9_at_corp.supernews.com>...
> "jamie smith" <jamie.smith_at_oracle.com> wrote in message
> news:sPDB7.194$78.32952_at_inet16.us.oracle.com...
> > Does anyone know where I can find some comparisons between the two? The
> > reason is to determine whether to use a BLOB to store text documents since
> I
> > am already using a BLOB for binary attachments. So, basically, is it
> > justifiable to differentiate between text and binary on data coming in and
> > placing that information in different locations...
> >
> > Any help would be appreciated.
> >
> > Thanks.
> >
> >
> >
> >
>
> Maybe we should just forward this post to Larry E.
> It is too damn stupid we are going to help Oracle people out who are not
> prepared to read their own manuals.
>
> Regards,
>
> Sybrand Bakker,
> Senior Oracle DBA
Received on Wed Oct 24 2001 - 20:10:22 CDT