My Oracle Support Banner

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 NOVEMBER 05, 2019

Applies to:

Oracle Text - Version 11.2.0.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

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


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