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

From: Jerra <jerra_at_aland.net>
Date: Thu, 05 Apr 2001 22:55:36 +0300
Message-ID: <3ACCCDB8.B7DBB038@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 Thu Apr 05 2001 - 14:55:36 CDT