2 Replies Latest reply on Oct 21, 2015 4:56 PM by 3054700

    Full-Text Search

    3054700

      I am using the Oracle-specific orardf:textContains SPARQL FILTER function to perform full-text searches on the MDSYS.RDF_VALUE$ table.

       

      Following the Spatial and Graph RDF Semantic Graph Developer's Guide 12c to create the index:

       

      EXECUTE SEM_APIS.ADD_DATATYPE_INDEX('http://xmlns.oracle.com/rdf/text');

       

      It works as expected but I would like to be able to perform "accent-insensitive" searches. I found that when creating the index with "CREATE INDEX", a custom lexer can be passed in parameters. Something like that:

       

      BEGIN
      CTX_DDL.create_preference( 'my_lexer', 'BASIC_LEXER');
      CTX_DDL.set_attribute('my_lexer', 'BASE_LETTER', 'true');
      CTX_DDL.set_attribute('my_lexer', 'OVERRIDE_BASE_LETTER', 'true');
      END;
      /
      
      CREATE INDEX my_index on TABLE (COLUMN)
        indextype is ctxsys.context
        parameters ( 'LEXER my_lexer' );
      
      

       

      I cannot figure out how to achieve the same result when creating the index with "SEM_APIS.ADD_DATATYPE_INDEX". Is it possible?


      Thank you