Results 1 to 2 of 2

Thread: Intermedia Text

  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Exclamation Unanswered: Intermedia Text

    We have Intermedia installed on oracle 8i database. I am playing with the tool to know more abt it. I created a table with 2 columns

    Name Null? Type
    ----------------------------------------- -------- --------------
    ID NOT NULL NUMBER
    MYTEXT VARCHAR2(200)

    Inserted a row 1,' This is to test'

    Indexed the column mytext and tried to query with the follwoing syntax

    select mytext from intermedtest where contains (mytext, 'This') > 0

    and I get now rows found , when I think I should get one row.

    I tried rebuilding the index..still no result.. Please help.

    I get a row if I search for
    select mytext from intermedtest where contains (mytext, 'This is to test') > 0

    Thank You

  2. #2
    Join Date
    Feb 2004
    Location
    Barcelona
    Posts
    3
    4 months later...

    The stopwords list must be avoiding "this" to be indexed so you won't find any document containing this word!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •