Re: Thesaurus Problem

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 FTS
http://www.indexserverfaq.com
"Organic Man" <davidmcmillin@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.



.

Relevant Pages

  • Re: Thesaurus Problem
    ... Unicode, Big Endian, and UTF-8. ... I rebooted my system and reopened Management Studio on the ... Developer's Edition of Sql Server 2005. ... SELECT FullDocNo ...
    (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: 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)
  • 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.programming)
  • 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.dotnet.framework.aspnet)
Loading