Special Characters in FullText Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marcus Baffa - 27 Jan 2005 20:19 GMT

I have create a Catalog and I am trying to find a record in the database that
satisfies the term: 102/3 or 102-3

These two terms works exactly the same way. The SQL searches for records
that have 102 or 3 in any position in the record, including in the middle of
a word.

I have concluded that these charecters represent separators and in fact I am
making a query to find records that have the two simple terms 102 or 3.

- Is it right ???? these charecters (/, -) have really the same effect. Are
both separators ????
- In that case where can I find a list of the other special use characters,
if they exist, and how they can be used ????
- How can I query the database to find the term "102-3" as it is written.
(By the way I have already tried to uses the double quotes and got the same
answer).

Thanks in Advance

Reply to this Message

John Kane - 28 Jan 2005 03:00 GMT

Marcus,
Could you post the full output of -- SELECT @@version -- as this is
especially important information for this type of SQL FTS issue?

While your questions are generic and understandable, the answers are highly
dependent upon the OS Platform (Windows 2000 Server vs. Windows Server 2003
or Windows XP) regardless of your SQL Server version (although, this too
would be helpful info).

Could you also post the SQL FTS query (contains or freetext) as well as true
sample of the data, including all punctuation characters relative to the
numbers, letters, and words you are searching for? Finally, the contents of
the language-specific noise word files, (noise.enu = US English) under
\FTDATA\SQLServer\Config\ as both single digit numbers and single letters
are by default included in the noise word files and this numbers and letters
are not FT Indexed and can affect your expected results.

Thanks,
John

Signature

SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

> I have create a Catalog and I am trying to find a record in the database that
> satisfies the term: 102/3 or 102-3
[quoted text clipped - 15 lines]
>
> Thanks in Advance

Reply to this Message