Hi, I'm browsing index word where the index was defined as mixed_case.
Only one document was entered as test case: the Oracle Text app. dev. guide.
Also I used the table solution, from jdbc.
Seed word was "A", requesting always 10 terms.
Straight table browsing ($i) reports around the "A" position:
It seems that this procedure fetches terms always in a case-insensitive way, in spite of index definition.
I'm also a bit confused by getting terms sorted as case-insensitive, although Oracle order-by clause should be case-sensitive by default.
I used a temp. table such as:
CREATE GLOBAL TEMPORARY TABLE BROWSE (
) ON COMMIT PRESERVE ROWS;
fetching as SELECT DOC_COUNT,WORD FROM BROWSE ORDER BY WORD ASC;
Thanks. This sound reasonable, although I wonder how a block of case-insensitive words can be fetched from a case-sensitive index.
Btw, I still don't understand why the select from the temp table returns a case-insensitive list (ok, this is the desired result in this case, by accident).