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

Thanks for the input!

Jerra

timkarnold wrote:
>
> 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
> >

Th Received on Sun Apr 08 2001 - 16:09:10 CDT