search brings no results

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dev (drychetnik_at_msn.com)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 14:15:49 +0200

I'm investigating SQL Server 2000 right now and I'm trying to get the see
how the full-text feature works using Word documents in different languages
(English, Persian, Arabic).

I modified the SQL Server Resource Kit sample called "Bulk Image Insert
(BII)" to put a few documents into the Northwind database. Then I created an
index on the column with an additional column that has the document type
'doc' in it and the language as neutral. I also populated the catalog. One
funny thing is that I only have 2 records in the table, but it now has 3
items in the catalog.

Anyhow, I haven't been able to get the query to work and at the moment I am
only trying English.

select * from test
where contains (i,'name')

I also tried putting a dot before the document type (.doc), but that didn't
work either.

I realize that this would probably be shot in the dark for anyone else to
try and solve, but thought someone might've run into the same problem. I'm
sure it is something very simple and stupid.

Relevant Pages

  • Re: Full-Text Catalog does not build...
    ... > stored in the FT Catalog. ... > Q.When can I read about languages were realized for FT in Yukon? ... > Vietnamese, Turkish, Arabic languages realized? ... > 2057 British English ...
    (microsoft.public.sqlserver.fulltext)
  • Re: A China-Sumer connection
    ... relatives speak on average 6 ... languages - fluently - and they are unrelated languages. ... learned English in a year. ... It's the nomads that are fluent in the ...
    (sci.archaeology)
  • Re: A China-Sumer connection
    ... relatives speak on average 6 ... languages - fluently - and they are unrelated languages. ... learned English in a year. ... It's the nomads that are fluent in the ...
    (sci.anthropology)
  • Re: A China-Sumer connection
    ... relatives speak on average 6 ... languages - fluently - and they are unrelated languages. ... learned English in a year. ... It's the nomads that are fluent in the ...
    (sci.lang)
  • Re: To Abu Azmi
    ... rightly envisaged primary education through a child’s mother tongue. ... English on a geographical spread. ... Hindi and other regional languages. ...
    (soc.culture.indian.marathi)