This discussion is archived
1 2 Previous Next 19 Replies Latest reply: Dec 18, 2012 7:21 PM by Barbara Boehmer RSS

Oracle TEXT: Contains  query is returning results only 4 certain paragraphs

yannisr Newbie
Currently Being Moderated
Environment:
OS: Win 7
Database Oracle Database 11g Express Edition Release 11.2.0.2.0 - Beta
APEX: 4.2


I created the following TEXT Index

begin
ctx_ddl.drop_preference ('docman_multi');
ctx_ddl.create_preference('docman_multi', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute('docman_multi', 'columns', 'CONTENTS, DESCRIPTION, CONTENTS, ATTR1 , ATTR2, ATTR3, RECEPIENTS, TAGS, COMMENTS');
end;


drop index DOCLIB_DOCS_IDX2

create index DOCLIB_DOCS_IDX2 on DOCLIB_DOCUMENTS (CONTENTS)
indextype is ctxsys.context
parameters ('datastore docman_multi section group CTXSYS.AUTO_SECTION_GROUP stoplist ctxsys.empty_stoplist sync (on commit)')


Then uploaded a couple of word documents with Greek characters.

then I use the query
select * from doclib_documents where contains( contents, :SEARCH_TEXT, 1) > 0

When I tried to search for Greek words it did not find anything. When I use English words (from the texts) it finds everything fine.

Is there anything particular I need to set to search non English characters?

Thank you
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points