Select statement with Unicode characters returns No Rows from a table with Oracle Text Index
(Doc ID 1332215.1)
Last updated on JUNE 22, 2011
Applies to:Oracle Text - Version: 10.2.0.5 to 220.127.116.11 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Running the query with divide symbol instead of umlautin the statement from SQL Developer returns "no rows":
SELECT * FROM info.DOKUMENT WHERE CONTAINS(DOKUMENT_BLOB,'Französisch') > 0;
no rows selected
Running the query with divide symbol instead of umlaut from SQL Developer returns many rows:
SELECT * FROM info.DOKUMENT WHERE CONTAINS(DOKUMENT_BLOB,'Franz÷sisch') > 0;
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.|