Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Searching Words in .RTF documents

9438Feb 16 2007 — edited Feb 20 2007
I have a problem with the use of "contains" option within .rtf document.
I have a table (note_tab) in which i put .rtf text:

note_tab (id integer,note varchar2(250));
with primary key on the column id.
Then I have a context index on the column "note":
CREATE INDEX note_idx ON note_tab(note) indextype IS ctxsys.context parameters ('FILTER CTXSYS.AUTO_FILTER');

I inserted in the table some text with .rtf format.
If I try to search some word with the "contains" option then it works.
But I have a problem: if i search a word that is in the table but having different font types, font dimensions, colors etc... in itself , then the "contains" command doesn't work.

For example if I look for the word "country" and this word is in the .rtf text (that I inserted in the table) but it is written like this "co[i]untry", then the "contains" command doesn't find it.

If I do the same thing with an HTML document (instead of a rtf document) using a context index with the NULL_FILTER option, it works!

So is there some option in the creation of the index to ensure the fact that, in .rtf documents, I can find also words with different fonts,dimensions etc.. within themselves?

Thank you
Massimo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2007
Added on Feb 16 2007
2 comments
1,221 views