Re: Long columns obsolete

"Robert" <cookie - remove - @tref.nl> wrote in message news:bqs78c$lh1$1_at_reader10.wxs.nl...
> Hi there,
>
>
> I have a third party application which uses a lot of LONG columns.
> I heard Oracle has them for backwards compatibility and from 9i they are
> obsolete.
>
> Is this true ? I can't seems to find a statement on this at the oracle
site
>
> If you had the choice would you use LONG's ?
>

Absolutely not. They've actually been deprecated since the invention of LOBs in 8.0.

After an exhaustive search of about 25 seconds, I came across this:

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfnstyp.htm#430644

wherein the quote is found:

"Oracle Corporation recommends using the LONG datatype only for backward compatibility with old applications. For new applications, you should use the CLOB and NCLOB datatypes for large amounts of character data. "

Regards
HJR

-- 
------------------------------------
Oracle insights at www.dizwell.com
------------------------------------