Forum Stats

  • 3,827,255 Users
  • 2,260,751 Discussions


Search with oracle text is not possible

Frank Lehmann
Frank Lehmann Member Posts: 126 Blue Ribbon
edited Dec 23, 2020 3:41PM in General Database Discussions


i am using oracle text to search etxt fields in the database.

Following phrase i want to find "TP-LINK TL-SG108 8-Port Gigabit Switch"

by searching "sg108"

This settings are made to create the text index:

filter:                       NULL_FILTER

section group:                NULL_SECTION_GROUP

lexer:                        BASIC_LEXER

  printjoins:                   -

  mixed_case:                   NO

wordlist:                     BASIC_WORDLIST

  stemmer:                      GERMAN

  fuzzy_match:                  GERMAN

The select statement is this: select * from table where contains(indexfield,'sg108')>0

But this results in null value.

Only this statement results in the correct way

select * from table where contains(indexfield,'%sg108%')>0

I think the (minus) sign is the problem, because it is a reserved word for searching text. But how to find text phrases which have this sign ?

I am not searching for the minus sign, so i can not know, that is there ?