Using Oracle Text with CLOB field containing multiple languages.
767006Apr 15 2010 — edited Apr 19 2010I'm using Oracle 10g and have a table with a CLOB field which is storing text written in either English and/or Simplified Chinese.
The following index has been created on this field:
CREATE INDEX text_index
ON text_table(text_field)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('FILTER CTXSYS.INSO_FILTER');
I'm having issues in returning text which matches the Chinese text using the CONTAINS operator. For some reason the following query is returning rows which do not contain any Chinese text:
SELECT *
FROM text_table
WHERE contains(text_field,'炫%') > 1;
The database NLS_CHARACTERSET is set to. AL32UTF8
Any information on what is causing this to happen will be much appreciated.