Unexpected Text Wildcard Query Results when First Word of is Chinese String with Both % Around the Word Returns None Results

(Doc ID 1437352.1)

Last updated on MARCH 16, 2012

Applies to:

Oracle Text - Version: and later   [Release: 11.2 and later ]
Oracle Text - Version: and later    [Release: 11.2 and later]
Information in this document applies to any platform.


No results are returned from both-side wildcard truncated query with Chinese search terms.
Problem only exist for the first Chinese word with double truncated wildcard query for chicken.


Searching for chicken '%鸡%' does not return the document with chicken 鸡 Vgram.

SQL> select * from test;

-- ----------------------------------------
1 鸡
2 cat

SQL> begin

PL/SQL procedure successfully completed.

SQL> create index testx on test (content) indextype is ctxsys.context
parameters ('lexer my_wlexer');

Index created.

SQL> select * from test where contains(content,'%鸡%') > 0

no rows selected


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