SQL 2005 Full Text Search / Contains Formsof Thesaurus not working

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » SQL 2005 Full Text Search / Contains Formsof...

SQL 2005 Full Text Search / Contains Formsof Thesaurus not working

Rate Topic

Display Mode

Topic Options

Author

Message

g_demetriou

Posted Wednesday, January 30, 2013 7:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 6, Visits: 59

Hi,

I can't seem to use a modified Thesaurus xml file on SQL 2005. I've modified the tsENG.xml, tsGLOBAL.xml, and the tsENU.xml files (all within the data folder - MSSQL.1\MSSQL\FTData) and then restarted the SQL Server Fulltext Search service. The following query isn't returning the expected results:

SELECT LookupString
FROM tblLookup 
WHERE CONTAINS(LookupString, ' FORMSOF (THESAURUS, SYS) ' );

All 3 xml's have:

<expansion>
            <sub>SYS</sub>
            <sub>System</sub>
            <sub>Systems</sub>
        </expansion>

I've also tried changing the following in the xml file from:

<diacritics_sensitive>0</diacritics_sensitive>

to:

<diacritics = false/>

this hasn't helped either.

In my SQL example above i'd like to return the column "LookupString", which contains either SYS or System or Systems, but it's only returning the specified one in the FORMSOF (THESAURUS, SYS) bit.

Any help would be appreciated.

Post #1413629

g_demetriou

Posted Wednesday, January 30, 2013 9:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:27 AM
Points: 6, Visits: 59

Deleting the Full-Text Index and then defining it again using the wizard seemed to fix it.

Post #1413687

« Prev Topic | Next Topic »

Permissions