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

Last updated on OCTOBER 11, 2013

Applies to:

Oracle Text - Version 11.2.0.2 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms