Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    TR
    Posts
    3

    Unanswered: Full text search on TEXT field

    I've a problem. I'm inexperienced about FTS.
    I have a TEXT datatype field in my table and I store MS Word documents.

    I want to do full text search on this TEXT datatype field.
    So I build catalog and run

    "Select * from table where Contains (textfield,'Yusuf')" sql in analyzer.

    but null value returns. however I know the table has 3 records.

    Anyway, I insert a varchar field in the table and edit my fts catalog.
    and then insert 3 records in the table.than rebuild catalog and I try
    "Select * from table where Contains (varcharfield,'Yusuf')"
    this sql returns true records.

    I know that I can FTS in TEXT datatype field but I can't. I don't know why.
    I need your help.
    thanks alot

    Yusuf

  2. #2
    Join Date
    Jan 2003
    Location
    TR
    Posts
    3

    ...

    Besides,
    I insert text in text datatype field and returs true values...

    The problem occours when insert only MS Word or MS Excel etc files.

Posting Permissions

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