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: 11.2.0.2 and later   [Release: 11.2 and later ]
Oracle Text - Version: 11.2.0.2 and later    [Release: 11.2 and later]
Information in this document applies to any platform.

Symptoms

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.

Example:

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

SQL> select * from test;

ID CONTENT
-- ----------------------------------------
1 鸡
2 cat

SQL> begin
ctx_ddl.create_preference('my_wlexer','WORLD_LEXER');
end;
/

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

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