Searching .. Re: [thesite] meta description

Dean Mah dmah at shaw.ca
Mon Jan 21 10:00:20 CST 2002


You're reading old documentation for Oracle7's ConText option.  In
Oracle8i things have changed.  The option is now called interMedia
Text.  LONG datatypes are deprecated and will be phased out of future
Oracle releases, at least that's the threat.

In general, Oracle doesn't have a TEXT datatype.  Any field text-like
column can be indexed by interMedia Text, i.e. VARCHAR, CHAR, CLOB,
and for backward-compatibility, LONG.

Dean


Warden, Matt writes:

> >><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> >> To what extent?
> >><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> >
> >supposedly just by referencing those columns with a CONTAINS clause.  dean?
> 
> i was under the impression CONTAINS was for text columns:
> 
> <wrapwatch>
> http://info-it.umsystem.edu/oradocs/doc/server/doc/CO20APP/ch02.htm#use1step
> http://info-it.umsystem.edu/oradocs/doc/server/doc/CO20APP/ch10.htm#fnccntn
> </wrapwatch>




More information about the thesite mailing list