Professional Web Applications Themes

Full Text Indexing - Microsoft SQL / MS SQL Server

I have a table using Full Text indexing on a column called Keywords: When I do a search on the database I am not getting results for certain searches: e.g.: Keywords field: 296924 : Electronica, Techno : Playful : Howly - 2.36 version. Upbeat trance techno beat with slight aerobics style music, synth arpeggios ping ponging back and forth and opera sample melodies. Slightly ethereal.. Fast tempo. Dance, Techno. De. DeBenedicti... If I do a Search for "296924" or "Playful" it doesn't work. The results below do come up when I do a search for playful 290415 : Acid Jazz ...

  1. #1

    Default Full Text Indexing

    I have a table using Full Text indexing on a column called Keywords:

    When I do a search on the database I am not getting results for certain
    searches:

    e.g.:

    Keywords field:
    296924 : Electronica, Techno : Playful : Howly - 2.36 version. Upbeat trance
    techno beat with slight aerobics style music, synth arpeggios ping ponging
    back and forth and opera sample melodies. Slightly ethereal.. Fast tempo.
    Dance, Techno. De. DeBenedicti...

    If I do a Search for "296924" or "Playful" it doesn't work.
    The results below do come up when I do a search for playful

    290415 : Acid Jazz : Playful : Fly - 1.20 minute version. Quirky jazzy
    acoustic bass claps sax. Fast tempo. Acid Jazz. N. Scragg. Intents
    Creative Music ASCAP.

    My search string is :
    SELECT * FROM CatalogItems WHERE CONTAINS(Keywords, 'Playful')

    Any ideas,

    Thanks,

    Eric Levin
    Sounddogs.com



    Eric Guest

  2. #2

    Default Re: Full Text Indexing

    Hi, Eric --

    What version of SQL Server are you using and what is your OS version as
    well? Also, what language are you using for Full-Text indexing this data?

    Has the particular row you are looking for definitely been Full-Text
    indexed? Do you find that row if you search for Howly or aerobics?

    Thanks,
    --andrew

    Andrew Cencini
    Program Manger
    Microsoft Corp. - SQL Server Engine

    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    "Eric Levin" <com> wrote in message
    news:phx.gbl... 
    trance 


    Andrew Guest

  3. #3

    Default Re: Full Text Indexing

    Andrew,

    This is SQL 2000 SP3 on Windows 2000 Server SP3.
    I am not sure what you mean by what language I am using. The Indexing is
    done directly in SQL Server, not using a programming language.

    The entired table has been indexed. If I look at the properties of the Full
    Text Catalog it contains the same number of rows as the table itself. I
    don't find this row if I search for Howly or Aerobics.
    There is a few rows in particular that I can't find.

    Thanks,

    Eric Levin
    Sounddogs.com

    "Andrew Cencini [MS]" <microsoft.com> wrote in message
    news:#phx.gbl... 
    rights. 
    > trance [/ref]
    ponging [/ref]
    tempo. 
    >
    >[/ref]


    Eric Guest

  4. #4

    Default Re: Full Text Indexing

    What I meant by language was the language used to wordbreak the text. One
    way to discover this is by executing sp_help_fulltext_columns to get the
    locale id.

    Out of curiosity, have you tried making some changes to the row that cannot
    be found (removed colons, etc)?
    Thanks,
    --andrew

    Andrew Cencini
    Program Manger
    Microsoft Corp. - SQL Server Engine

    --
    This posting is provided "AS IS" with no warranties, and confers no rights.


    "Eric Levin" <com> wrote in message
    news:phx.gbl... 
    Full [/ref]
    data? 
    > rights. [/ref][/ref]
    certain 
    > > trance [/ref]
    > ponging [/ref]
    > tempo. [/ref][/ref]
    jazzy 
    > >
    > >[/ref]
    >
    >[/ref]


    Andrew Guest

  5. #5

    Default Re: Full Text Indexing

    Eric,

    Also, are there spaces between the colons/commas, etc? I tried out the
    following on a machine like yours:

    /*------------------------------------------------------------*/

    insert music values(1, '296924 : Electronica, Techno : Playful : Howly -
    2.36 version. Upbeat trance
    techno beat with slight aerobics style music, synth arpeggios ping ponging
    back and forth and opera sample melodies. Slightly ethereal..')

    insert music values(2, '296924:Electronica,Techno:Playful:Howly - 2.36
    version. Upbeat trance
    techno beat with slight aerobics style music, synth arpeggios ping ponging
    back and forth and opera sample melodies. Slightly ethereal..')

    /*------------------------------------------------------------*/

    For this query, row 1 is returned, but not row 2.

    select * from music where contains(text, 'Playful')

    I am still stumped as to why aerobics is not found though. If there is some
    way to re-try indexing of just that row (or the whole table if it is small
    and not in production) it could also be that somehow that or other rows were
    somehow missed. Are there any strange errors in the application event log
    from Microsoft Search or MSSCi?

    Thanks,
    --andrew

    Andrew Cencini
    Program Manger
    Microsoft Corp. - SQL Server Engine

    --
    This posting is provided "AS IS" with no warranties, and confers no rights.


    "Andrew Cencini [MS]" <microsoft.com> wrote in message
    news:phx.gbl... 
    cannot 
    rights. 
    > Full [/ref][/ref]
    as [/ref]
    > data? 
    > > rights. [/ref]
    > certain [/ref][/ref]
    Upbeat 
    > > ponging 
    > > tempo. [/ref]
    > jazzy 
    > >
    > >[/ref]
    >
    >[/ref]


    Andrew Guest

Similar Threads

  1. Full Text display problem in MySQL Text column
    By Clint_Ribble in forum Coldfusion Database Access
    Replies: 2
    Last Post: November 8th, 05:09 PM
  2. Replies: 0
    Last Post: June 14th, 12:29 PM
  3. CFMX 7 Verity issue with indexing full query resultsproperly
    By Pranic in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: June 8th, 12:16 AM
  4. Need a full-text indexing application for PDF, DOC, TXT and HTM files
    By Vulpes Argenteus in forum Adobe Acrobat Windows
    Replies: 4
    Last Post: April 22nd, 10:13 PM
  5. Full-text Index bug
    By Dinesh.T.K in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 22nd, 07:02 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139