Re: Indexing for Oracle Text

From: Can Oezdemir <no_at_spam.net>
Date: Fri, 30 May 2003 09:44:13 +0200
Message-ID: <bb724b$6iopg$1@ID-194392.news.dfncis.de>

Hi Thomas,

> When you are building the text index oracle is storing the tokens in
> DR$<>$I and they are store either in UPPERCASE or MIXEDCASE (lexer pref:
> MIXED_CASE). If you have your index created with MIXED_CASE=YES then
> both queries will find the correct documents:
> - contains(index,'lower case token')>0
> - contains(index,'upper case token')>0
>
> because oracle is using UPPER(tokens) and then search in the index.
>
> Is that what you wanted to know ?
>

Yeah, that's what I needed to know :) - Actually I had created a default index and only specified that the INSO filter should be used. Then according to what you wrote, and according to the Oracle documentation the tokens should have all been uppercase (default). But they weren't... :) So I recreated the index, explicitly specifying mixed_case as off. Now it works :)

Thank you for your help.

Best regards,

Can Received on Fri May 30 2003 - 02:44:13 CDT