Hi all,
I have inserted in my column the german texts and set the preference composite in basic_lexer.

CallableStatement cstmt;
Statement stmt = conn.createStatement();
cstmt = conn.prepareCall("{call Ctx_Ddl.Drop_Preference(?)}");
cstmt.setString(1, "composite_lexer");
cstmt.execute();
cstmt = conn.prepareCall("{call Ctx_Ddl.Create_Preference(?, ?)}");
cstmt.setString(1, "composite_lexer");
cstmt.setString(2, "BASIC_LEXER");
cstmt.execute();
cstmt = conn.prepareCall("{call Ctx_Ddl.Set_Attribute(?, ?, ?)}");
cstmt.setString(1, "composite_lexer");
cstmt.setString(2, "composite");
cstmt.setString(3, "GERMAN");
cstmt.execute();

CREATE INDEX oracle_index_intern ON texttable_intern(content) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('LEXER composite_lexer')

I want to search the documents, in which contain the search term "Geschichte" oder composite words for example "Kulutrgeschichte". But i get the results, in which contain just only the single wort "Geschichte". Mein query:
SELECT titel, text_typ FROM texttable_intern WHERE CONTAINS (content, 'Geschichte', 1)>0

I don't know what's wrong with this? Can you give me any tipps?


Thank you for your help and greeting aus germany


rabbit