Oracle Text Contains With Stemming Returns Different Results In German
(Doc ID 1563636.1)
Last updated on APRIL 30, 2020
Applies to:
Oracle Text - Version 11.2.0.3 and laterInformation in this document applies to any platform.
Goal
The same query using contains against XML data returns different results if nls_language is different, e.g. for word Venezuela.
alter session set nls_language='french';
select * from iris_fulltext where contains(rawcontent,'$venezuela within text',0)>0;
-> returns 457 matching rows
alter session set nls_language='german;
select * from iris_fulltext where contains(rawcontent,'$venezuela within text',0)>0;
-> returns no rows
Solution
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
Goal |
Solution |
References |