No results returned when using CONTAINS and WITHIN operator with Turkish data (Doc ID 1591338.1)

Last updated on APRIL 07, 2022

Applies to:

Symptoms

Querying a Text indexed column using CONTAINS(..within..) having Turkish data returns no rows ; even thought data exists:

SQL> ALTER SESSION set NLS_SORT='XTurkish';

Session altered.

drop index MYTEXT_IDX;

ALTER SESSION set NLS_SORT='XTurkish';

exec ctx_ddl.create_preference('turk_lexer', 'basic_lexer');

CREATE INDEX MYTEXT_IDX ON txmldocs
(DETS)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('LEXER SYS.turk_lexer
STORAGE SYS.MY_storage
DATASTORE SYS.MYDATA
SECTION GROUP SYS.tez_section
sync(EVERY "sysdate+1/24 " )
MEMORY 1024M')
ONLINE
PARALLEL 4;

SQL> select id,Data,Data2 from txmldocs
 2  WHERE CONTAINS(DETS, 'Data2:s'||chr(50353)||'nirli within DATA2') > 0;


no rows selected

select id,Data,Data2 from txmldocs;

       ID
----------

DATA
--------------------------------------------------------------------------------

DATA2
--------------------------------------------------------------------------------

       10
Data:sinirli
Data2:sinirli

        2
oracle Data:sinirli
Data2:sinirli

        1
Data:sinirli
Data2:sinirli

        3
Data:sinirli

Data2:sinirli

        5
oracle Data:sinirli
Data2:sinirli

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.