My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.