1 2 Previous Next 19 Replies Latest reply: Dec 18, 2012 9:21 PM by Barbara Boehmer RSS

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

    yannisr
      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