[Theforum] New feature suggestions

Dean Mah dmah at shaw.ca
Fri Nov 16 10:43:01 CST 2001

You can use DBMS_LOB.INSTR (a built-in Oracle stored proc) to do
case-sensitive searches of CLOB datatypes.  I used that for searching
thetips.  And if we had the InterMediaText option, we could add
indexing of CLOB types and searching.  I'm not sure if InterMediaText
comes with Oracle by default (I doubt it).  I'm thinking about writing
a stored proc to do case in-sensitive search but I'm not sure what
kind of performance that we would get.

Oh, we'd also have to convert from using LONGs to CLOBs.


.jeff writes:

> if we *ever* get the search engine working so that it searches the
> body of the article as well then it'll be crucial that this
> non-article related material doesn't factor into the results.

More information about the theforum mailing list