Re: Thesaurus on full-text search is not working

Sorry, guys, I did a ton of Googling before I posted this, but then, of
course, I saw this:

http://groups.google.com/group/microsoft.public.sqlserver.fulltext/browse_thread/thread/1560031044204408/36ef0c301150aa4a?lnk=gst&q=thesaurus&rnum=2#36ef0c301150aa4a

Essentially, this guy was having the same problem I was... the thesaurus
wasn't working because he was using TextPad which I also use, which saves
ANSI text by default. Sql Server wants Unicode and when I changed TextPad
to save as unicode, it worked.

Richard

"Richard A. Lowe" <chadich@xxxxxxxxx> wrote in message
news:eH13oEYzGHA.4448@xxxxxxxxxxxxxxxxxxxxxxx
Hi all, here's my setup:

Sql Server 2005 on Windows Server 2003 (standard). I have a datbase (Sql
90 compatibility level). I have very trivial example set up to try to get
the thesaurus to work.

My table:
CREATE TABLE TestData
(
TestDataID int PRIMARY KEY NOT NULL IDENTITY(1, 1),
TestData varchar(max) NOT NULL
)
go
-- the data:
insert into TestData(TestData) values('book')
insert into TestData(TestData) values('article')

Ok, so I create a full-text index on this table/data, then modify my
thesaurus file (tsEnu.xml) to this.
<XML ID="Microsoft Search Thesaurus">
<expansion>
<sub>book</sub>
<sub>article</sub>
</expansion>
</XML>

Then I re-start the Sql Server and Sql Full text services. Then I issue
the following query:
select * from ContainsTable(dbo.TestData, *, 'FORMSOF(THESAURUS, book)')

and it returns ONLY the key and rank of the row with 'book' in it. Using
FileMon from sysinternals, I can see that the tsEnu.xml and tsGlobal.xml
are queried by the msftesql.exe process (upon running the query) making me
think they should be working.

I have tried many combinations of the data, query syntax (like adding
dbl-quotes around book etc.) but there is no result of the expanded (or in
the cases I tried it a replacement).

Can someone offer some insight into how to troubleshoot this?

Thanks!
Richard Lowe



.

Relevant Pages

  • Re: Any Full-Text Gurus - Need help with a query
    ... that the thesaurus has an expansion on. ... Every record with car, auto, wash, ... required in the query, database, or app. ... > Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Any Full-Text Gurus - Need help with a query
    ... There is no way to spill the thesaurus or inflectional terms in your query. ... > inflectionals as well and I "ain't" no english major if you know what I ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.fulltext)
  • Thesaurus on full-text search is not working
    ... TestDataID int PRIMARY KEY NOT NULL IDENTITY, ... TestData varcharNOT NULL ... thesaurus file to this. ... queried by the msftesql.exe process (upon running the query) making me think ...
    (microsoft.public.sqlserver.fulltext)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
Loading