Tokens case sensitive in $I table with mixed_case=NO
391632Apr 3 2003 — edited May 5 2003We are experiencing this problem:
Oracle Text indexes some tokens in a case sensitive way, although we create the index with a BASIC_LEXER preference that indicates mixed_case = NO. In the documentation it is said that with that parameter in the LEXER, tokens will be indexed and stored in DR$<my_index>$I table all in Uppercase.
The tokens that appear in case sensitive form are those like "Oracle9i", that has manny entries in DR$<my_index>$I table as "ORACLE9I", or "oracle9i".
This happens with the following configuration:
Oracle9i Enterprise Edition Release 9.2.0.2.1
select * from ctx_version -> VER_DICT: 9.2.0.1.0, VER_CODE: 9.2.0.2.0
DATABASE in UTF8 CHARSET.
However it does not happen when the database is in WE8ISO8859P1 charset or in a previous release of oracle (9.2.0.1, and 8.1.7.3.0)
This is an annoying issue, becaous in our aplication we make the assumption that the indexer is case INsensitive...
Can anybody help me?
Thanks in advance.