Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / November 2005

Tip: Looking for answers? Try searching our database.

question about full-text search

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gordowey - 21 Nov 2005 14:16 GMT
Hi all,

I have a single table (TAB_FULL_TEXT_NET) , with only one field indexed
in my sql catalog.
I am runing  queries agaist the catalog  using CONTAINSTABLE

  select     [KEY] objDocumento,  tf.RANK RANK  from
CONTAINSTABLE(TAB_FULL_TEXT_NET, *, '42.55.14.1.2', 300) tf

The problem is that some results returned by the query do not to mach
my search. How can this be possible.

For example i am looking for: 42.55.14.1.2

but some results containing similar words like
42.55.14.2
42.55.14.9.3
42.55.14.6.1

are also returned in the results set

Questions:
1.- Does the CONTAINSTABLE have problems to deal with period '.'
2.- How can I limit my search only to exact words

obs: I have also tried to put the search word into "" (ex:
"42.55.14.1.2") , but same results

Thank you very much

Alberto
Hilary Cotter - 21 Nov 2005 14:59 GMT
Yes, it thinks the . is white space, so your search is done on 42 55 14 1 2.
Matches will be to 42 55 14 1 2 or 42!55!14!1!2, in other words any non
alphanumeric character between the numbers will yield a match.

however, I am unable to repro your problem. Can you tell me what version of
SQL you are running, and the version of the OS, also please issue the
following query and tell me what you get.

select @@language.

What word breaker are you using?

Signature

Hilary Cotter
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

> Hi all,
>
[quoted text clipped - 27 lines]
>
> Alberto
Gordowey - 21 Nov 2005 17:47 GMT
Thanks for your quick answer!

well I am using English (USA) as word breaker, but most of the text is
in portuguese ! (is that a problem?)

about the version, see below
Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002
14:22:05   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

what do you suggest me to deal with that situation?..

thanks

Alberto
Hilary Cotter - 21 Nov 2005 18:57 GMT
Are the documents stored in the image data type column? Are there any html
tags in the content?

Signature

Hilary Cotter
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

> Thanks for your quick answer!
>
[quoted text clipped - 11 lines]
>
> Alberto
Gordowey - 21 Nov 2005 19:47 GMT
Hi again..

well, I have 2 tables in my catalog

Table 1: one (only text) field indexed
Table 2: One binary field indexed

about html text....not in the text field (table 1), but i am not sure
about Table 2, because users can include html files in the binary
field....

well, any help to deal with the period ('.') would be apreciated....

thanks

Alberto
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.