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: 18.104.22.168
Oracle Text - Version: 22.214.171.124 and later [Release: 11.2 and later]
Information in this document applies to any platform.
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;
PL/SQL procedure successfully completed.
SQL> create index testx on test (content) indextype is ctxsys.context
parameters ('lexer my_wlexer');
SQL> select * from test where contains(content,'%鸡%') > 0
no rows selected
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
|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.|