Re: Thesaurus Problem

On Aug 30, 7:37 am, "Jean-Pierre Riehl" <jean-pierre.ri...@b-e-w-i-s-
e.fr> wrote:
Hi ,

Go back to the begining, Let's try the empirical way.

Can you create a table with a varchar(max) column, for example, populate it
with 'run' and 'jog' terms.
Then create a Full-Text Index, forcing indexation language.

CREATE FULLTEXT INDEX on AnotherTryTable
( [Description] LANGUAGE 1033)
KEY INDEX PK_ThePK
ON NewCatalog

Start with a fresh tsENU.xml file and ensure comments tag <!-- --> are
removed.
Try to search against 'run' or 'jog' and tell us your results.

--
Jean-Pierre Riehlhttp://blog.djeepy1.nethttp://www.bewise.fr

Hi Jean-Pierre,

Here is what I did:

CREATE TABLE dbo.AnotherTryTable
(ID int Primary Key IDENTITY(1,1) NOT NULL,
Description nvarchar(Max) NOT NULL)

INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('run')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('run')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('run')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('run')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('jog')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('jog')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('jog')
INSERT INTO [dbo].[AnotherTryTable] ([Description])
VALUES ('jog')

CREATE UNIQUE INDEX ui_AnotherTry ON AnotherTryTable(ID);
CREATE FULLTEXT CATALOG NewCatalog AS DEFAULT;
CREATE FULLTEXT INDEX on AnotherTryTable
( [Description] LANGUAGE 1033)
KEY INDEX ui_AnotherTry
ON NewCatalog

I created a new tsENU.xml using Dreamweaver, first a plain xml and
then with the "Include Unicode Signature (BOM)" selected. Figured
this is a good idea since the MSDN documentation insists on BOM.

I rebooted my system after any changes to the xml file, but always the
same results:

SELECT Description
FROM AnotherTryTable
WHERE CONTAINS(Description, 'run'); *** 4 results ***

SELECT Description
FROM AnotherTryTable
WHERE CONTAINS(Description, 'jog'); *** 4 results ***

SELECT Description
FROM AnotherTryTable
WHERE CONTAINS(Description, ' FORMSOF(THESAURUS, run) ') *** 4
results ***

.

Relevant Pages

  • Probleme mit CREATE FULLTEXT INDEX
    ... liefert mir folgende Fehlermeldung: ... CREATE FULLTEXT INDEX ON dbo.ArticlesKEY INDEX ui_ukArticle ON ...
    (microsoft.public.de.sqlserver)
  • Re: Character Problems
    ... and does the fulltext index will incres 1 time when we change the nText to ... Language for Word Breaker? ... > reference your database and table and then change the nText column to use ... > SQL Server Require N Prefix" ...
    (microsoft.public.sqlserver.fulltext)
  • Error 7653 when executing CREATE FULLTEXT INDEX
    ... CREATE FULLTEXT INDEX ... KEY INDEX ID ... WITH CHANGE_TRACKING AUTO; ... The message states that ID is an invalid column because it must not ...
    (microsoft.public.sqlserver.fulltext)
Loading