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: Oracle 8.0.5, Context Cartridge, Columns with 4000+ characters of data

Re: Oracle 8.0.5, Context Cartridge, Columns with 4000+ characters of data

From: timkarnold <timkarnold_at_home.com>
Date: Fri, 06 Apr 2001 11:54:33 GMT
Message-ID: <Z7iz6.27447$iU.5293220@news1.rdc1.md.home.com>

For 8.0.5, I'm not sure what support there is, but it would be CLOB if character data.
or BLOB for WORD docs and such in 8i. LONGs will work for Context - we still use them,but they can be hard to work with.

"Jerra" <jerra_at_aland.net> wrote in message news:3ACCCDB8.B7DBB038_at_aland.net...
> Hi,
> The app server which would use this column is written in Java and uses
> JDBC.
> Have some questions regarding columns holding a large amount of
> character data.
>
> The context cartridge:
> Will this only work with the normally used datatypes (varchar2,
> char) ?
>
> Large character columns:
> Which column to use for sizes above 4000characters? All
> columns(long,clob) seems to be so difficult manage.
> LONG cannot be indexed and has a shitload of restrictions when
> dealing with expressions, ie cannot be used in a WHERE clause.
>
> In other words what datatype to use that would be (close to) the SQL
> Server TEXT datatype?
>
> TIA!
>
> Best Regards
> Jerra
>
Received on Fri Apr 06 2001 - 06:54:33 CDT

Original text of this message

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