question about full-text search

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
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?
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
"Gordowey" <albertoiriarte@.gmail.com> wrote in message
news:1132582567.679893.208520@.g14g2000cwa.googlegr oups.com...
> 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
>
|||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
|||Are the documents stored in the image data type column? Are there any html
tags in the content?
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
"Gordowey" <albertoiriarte@.gmail.com> wrote in message
news:1132595252.224093.110370@.g49g2000cwa.googlegr oups.com...
> 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
>
|||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

Question about FullText Search

Hi eveyone,

I have a fullText catalog for a very simple table with 3 rows which contains text like below:

Row 1==> First term, Second term 4-3/16" third term 14.75 forth term 998 3-3/8" 8911 8
Row 2==> First term, Second term 5-3/16" third term 14.95 forth term 11
Row 3==> First term, Second terms 2/18" third term 14.07 forth term 3-3/8" 3

When I try to run query:

1. Select * from myFullText where contains(Text, '3/16') return row 1 and 2 ( ok )
2. Select * from myFullText where contains(Text, '11-3/8') ==> return row 2 (matching 11 only)
3. Select * from myFullText where contains(Text, '3-3/8') return no record
4. Select * from myFullText where contains(Text, '3/8') return no record

If someone do understand about Microsoft FullText search, please help me by explain to me why the output for sql #2, 3 and 4 are like that.

Regards,

John Dang

FYI,

Currently I am using SqlServer 2005, english language and Window XP Pro OS.

JDang

|||

Workaround:

Add more keywords:

3-3/8 + 3/8 + 3-3 + 3 + 338 ...

Consider to eliminate slashes and dashes

Make sure that noisewords do not disdurb. ( I dont know enough about when they are used )

Thomas Boffo

Question about FullText Search

Hi eveyone,

I have a fullText catalog for a very simple table with 3 rows which contains text like below:

Row 1==> First term, Second term 4-3/16" third term 14.75 forth term 998 3-3/8" 8911 8
Row 2==> First term, Second term 5-3/16" third term 14.95 forth term 11
Row 3==> First term, Second terms 2/18" third term 14.07 forth term 3-3/8" 3

When I try to run query:

1. Select * from myFullText where contains(Text, '3/16') return row 1 and 2 ( ok )
2. Select * from myFullText where contains(Text, '11-3/8') ==> return row 2 (matching 11 only)
3. Select * from myFullText where contains(Text, '3-3/8') return no record
4. Select * from myFullText where contains(Text, '3/8') return no record

If someone do understand about Microsoft FullText search, please help me by explain to me why the output for sql #2, 3 and 4 are like that.

Regards,

John Dang

FYI,

Currently I am using SqlServer 2005, english language and Window XP Pro OS.

JDang

|||

Workaround:

Add more keywords:

3-3/8 + 3/8 + 3-3 + 3 + 338 ...

Consider to eliminate slashes and dashes

Make sure that noisewords do not disdurb. ( I dont know enough about when they are used )

Thomas Boffo

Question about catalog schedule

When I start a full population on a full_text catalog manually (Right click
on a full_text catalog and click start full_text population), it works
perfectly. But when I try to schedule a full pupulation on the same catalog,
it seems like it never start to do the full population. Do I need to set up
something in sql server inorder to invoke the event?
Thanks you.
no, you should not have to do anything special.
Check the gatherer logs to see if the population happend. You can find them
in
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\GatherLogs
Use gthrlog.vbs to interpret them. You can find this in:
C:\Program Files\Common Files\System\MSSearch\Bin
Copy it to %windir%\system32 and you can run this script anywhere.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:D7BFE12F-8A58-417F-AC5B-DA33792ADAB3@.microsoft.com...
> When I start a full population on a full_text catalog manually (Right
click
> on a full_text catalog and click start full_text population), it works
> perfectly. But when I try to schedule a full pupulation on the same
catalog,
> it seems like it never start to do the full population. Do I need to set
up
> something in sql server inorder to invoke the event?
> Thanks you.
|||Tom,
Could you review your server's Application event log for "Microsoft Search"
and MssCi source events? Both of these events record the success and failure
of an attempted Full Population. If there are any errors near the time that
you attempted a scheduled SQLServerAgent job, could you post the event text?
Thanks,
John
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:D7BFE12F-8A58-417F-AC5B-DA33792ADAB3@.microsoft.com...
> When I start a full population on a full_text catalog manually (Right
click
> on a full_text catalog and click start full_text population), it works
> perfectly. But when I try to schedule a full pupulation on the same
catalog,
> it seems like it never start to do the full population. Do I need to set
up
> something in sql server inorder to invoke the event?
> Thanks you.