Re: Thesaurus Problem

On Aug 27, 10:49 pm, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
Did you save your thesaurus file with Unicode encoding? After SP 2 it must
be saved as a Unicode file.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Organic Man" <davidmcmil...@xxxxxxx> wrote in message

news:1188250168.087879.56150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am trying to get the full-text search thesaurus to work in Sql
Server 2005 Express edition. I live in the USA so I assume the
tx.ENU.xml is the appropriate file to modify. I used Notepad to
modify the tx.ENU.xml file and saved as unicode:

<XML ID="Microsoft Search Thesaurus">

<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>littre</sub>
<sub>leydig</sub>
</expansion>
<replacement>
<pat>NT5</pat>
<pat>W2K</pat>
<sub>Windows 2000</sub>
</replacement>
<expansion>
<sub>run</sub>
<sub>jog</sub>
</expansion>
</thesaurus>

</XML>

I closed Management Studio and reopened to allow MSFTESQL service to
restart. Then I ran these queries:

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'littre') *** returned 3 rows ***

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, 'leydig') *** returned 169 rows ***

SELECT FullDocNo
FROM FullDocuments
WHERE CONTAINS(SectionText, ' FORMSOF(THESAURUS, littre) ') ***
returned 6 rows ***

Thus the Thesaurus does not seem to be working since it should have
returned at least 169 rows. I rebooted my entire system to make sure
Sql Server is starting fresh.

Any help in sorting this out will be greatly appreciated.


Hi Hilary,

Yes, I saved as unicode and double checked to be sure.

Are there any specific instructions for restarting MSFTESQL service,
other than closing and reopening Management Studio?

Does the full-text catalog need to be updated?

.

Relevant Pages

  • Re: Thesaurus Problem
    ... Looking for a SQL Server replication book? ... be saved as a Unicode file. ... FROM FullDocuments ...
    (microsoft.public.sqlserver.fulltext)
  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... After checking with Microsoft it turns out that transmitting Unicode ... requires a change in the data format sent to the JDBC Receiver channel. ... We have contacted SAP and Microsoft. ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Thesaurus Problem
    ... be saved as a Unicode file. ... FROM FullDocuments ... Sql Server is starting fresh. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Thesaurus Problem
    ... sp_configure 'default full-text language' ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html ... FROM FullDocuments ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How to store HTML code in SQL server table
    ... but varchar cannot be properly used with unicode ... and has a maximum length of 8000 characters. ... > I support the Professional Association of SQL Server and it's> community of SQL Server professionals. ... >> I'm creating something like a web site builder in ASP.Net, and I need to>> store an HTML code in the SQL server table. ...
    (microsoft.public.sqlserver.server)