FULL TEXT SEARCH PROBLEM

I deleted all noise words and chars in noiseXX..txt files. I know that it is
not a noise word issue.



"Hilary Cotter" , haber iletisinde sunlari
yazdi:fced9e28-2f5a-4111-b32a-7db63180edf0@q77g2000hsh.googlegroups.com...
you need to prepend a noise word on your query, ie:

use pubs
GO
create table fttable (pk int not null identity constraint fttablepk
primary key,
charcol char(200))
GO
insert into fttable values('516.32')
insert into fttable values('T17.1.516.32')
GO
sp_fulltext_database 'enable'
GO
create fulltext catalog test as default
GO
create fulltext index on fttable(charcol) key index fttablepk
GO
select * from fttable where contains(*,'516.32')--hit to 516.32
select * from fttable where contains(*,'1.516.32.1')--hit to
T17.1.516.32
select * from fttable where contains(*,'1.516.32')--hit to
T17.1.516.32


On Feb 1, 3:02 am, "in da club" <s> wrote:
> I have a table which has a record T17.1.516.32
>
> I try
> SELECT Urun_Ad as guUrun_Ad
>
> FROM TBL_URUNLER
>
> WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' )
>
> ))
>
> it returns T17.1.516.32
>
> i try
>
> SELECT Urun_Ad as guUrun_Ad
>
> FROM TBL_URUNLER
>
> WHERE ( (CONTAINS(Urun_Ad, '"*1.516.32*"' )
>
> ))
>
> it returns
>
> T17.1.516.32
>
> and i try
>
> SELECT Urun_Ad as guUrun_Ad
>
> FROM TBL_URUNLER
>
> WHERE ( (CONTAINS(Urun_Ad, '"*516.32*"' )
>
> ))
>
> it returns nothing. How can i solve the problem. i need like operator task
> in fts.
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

Add them back in.

Basically SQL FTS considers the * to be noise, so if what you are
looking for is also noise SQL FTS will be unable to tell them apart.

On Feb 6, 6:10 am, "Daniel Crichton" wrote:
> in wrote  on Wed, 6 Feb 2008 09:48:07 +0200:
>
> > I deleted all noise words and chars in noiseXX..txt files. I know that
> > it is  not a noise word issue.
>
> Why are you using * at the start of terms? FTS just ignores that, it's not
> part of the documentation.
>
> As to why it's not working, no idea. After you deleted the noise words did
> you do a full rebuild?
>
> Dan
>
>
>
>
>
> > "Hilary Cotter" , haber iletisinde sunlari yazdi:fced9e28-2f5a-4111-b32a-7db63180e...@q77g2000hsh.googlegroups.com.
> > ..
> > you need to prepend a noise word on your query, ie:
> > use pubs
> > GO create table fttable (pk int not null identity constraint fttablepk
> > primary key, charcol char(200))
> > GO insert into fttable values('516.32')
> > insert into fttable values('T17.1.516.32')
> > GO sp_fulltext_database 'enable'
> > GO create fulltext catalog test as default
> > GO create fulltext index on fttable(charcol) key index fttablepk
> > GO select * from fttable where contains(*,'516.32')--hit to 516.32
> > select * from fttable where contains(*,'1.516.32.1')--hit to
> > T17.1.516.32 select * from fttable where contains(*,'1.516.32')--hit to
> > T17.1.516.32
> > On Feb 1, 3:02 am, "in da club" <s> wrote:
>
>  >> I have a table which has a record T17.1.516.32
>
>  >> I try
>  >> SELECT Urun_Ad as guUrun_Ad
>
>  >> FROM TBL_URUNLER
>
>  >> WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' )
>
>  >> ))
>
>  >> it returns T17.1.516.32
>
>  >> i try
>
>  >> SELECT Urun_Ad as guUrun_Ad
>
>  >> FROM TBL_URUNLER
>
>  >> WHERE ( (CONTAINS(Urun_Ad, '"*1.516.32*"' )
>
>  >> ))
>
>  >> it returns
>
>  >> T17.1.516.32
>
>  >> and i try
>
>  >> SELECT Urun_Ad as guUrun_Ad
>
>  >> FROM TBL_URUNLER
>
>  >> WHERE ( (CONTAINS(Urun_Ad, '"*516.32*"' )
>
>  >> ))
>
>  >> it returns nothing. How can i solve the problem. i need like operator
>  >> task in fts.- Hide quoted text -
>
> - Show quoted text -
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

in wrote on Wed, 6 Feb 2008 09:48:07 +0200:

> I deleted all noise words and chars in noiseXX..txt files. I know that
> it is not a noise word issue.


Why are you using * at the start of terms? FTS just ignores that, it's not
part of the documentation.

As to why it's not working, no idea. After you deleted the noise words did
you do a full rebuild?

Dan



> "Hilary Cotter" , haber iletisinde sunlari yazdi:fced9e28-2f5a-4111-b32a-7db63180edf0@q77g2000hsh.googlegroups.com.
> ..
> you need to prepend a noise word on your query, ie:

> use pubs
> GO create table fttable (pk int not null identity constraint fttablepk
> primary key, charcol char(200))
> GO insert into fttable values('516.32')
> insert into fttable values('T17.1.516.32')
> GO sp_fulltext_database 'enable'
> GO create fulltext catalog test as default
> GO create fulltext index on fttable(charcol) key index fttablepk
> GO select * from fttable where contains(*,'516.32')--hit to 516.32
> select * from fttable where contains(*,'1.516.32.1')--hit to
> T17.1.516.32 select * from fttable where contains(*,'1.516.32')--hit to
> T17.1.516.32


> On Feb 1, 3:02 am, "in da club" <s> wrote:
>> I have a table which has a record T17.1.516.32

>> I try
>> SELECT Urun_Ad as guUrun_Ad

>> FROM TBL_URUNLER

>> WHERE ( (CONTAINS(Urun_Ad, '"*t17.1.516.32*"' )

>> ))

>> it returns T17.1.516.32

>> i try

>> SELECT Urun_Ad as guUrun_Ad

>> FROM TBL_URUNLER

>> WHERE ( (CONTAINS(Urun_Ad, '"*1.516.32*"' )

>> ))

>> it returns

>> T17.1.516.32

>> and i try

>> SELECT Urun_Ad as guUrun_Ad

>> FROM TBL_URUNLER

>> WHERE ( (CONTAINS(Urun_Ad, '"*516.32*"' )

>> ))

>> it returns nothing. How can i solve the problem. i need like operator
>> task in fts.
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

it is not a noise word issue.
I try SND191P
it returns SND191P ( it is stored as SND191P in db)

However When i try 191P it returns nothing.
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

in wrote on Wed, 6 Feb 2008 19:12:10 +0200:

> it is not a noise word issue.
> I try SND191P it returns SND191P ( it is stored as SND191P in db)

> However When i try 191P it returns nothing.

That's how it should work, FTS looks for whole words, or prefix's. It does
not allow searching for the end or middle of words.

When you say you cleared out the noise word file, did you remember to leave
a single space in it?

--
Dan
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

my trick only works if there is a . or another character that sql fts
recognizes as a word boundary marker like . or ! or ?, and sometimes
-.

you will have to do a like.


On Feb 6, 12:12 pm, "in da club" <s> wrote:
> it is not a noise word issue.
> I try  SND191P
> it returns SND191P ( it is stored as SND191P in db)
>
> However When i try 191P it returns nothing.
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

My trick only works with a . or other word boundary descriminator
like ? or ! or , and some others.

You will need to do a like.

On Feb 6, 12:20 pm, "Daniel Crichton" wrote:
> in wrote  on Wed, 6 Feb 2008 19:12:10 +0200:
>
> > it is not a noise word issue.
> > I try  SND191P it returns SND191P ( it is stored as SND191P in db)
> > However When i try 191P it returns nothing.
>
> That's how it should work, FTS looks for whole words, or prefix's. It does
> not allow searching for the end or middle of words.
>
> When you say you cleared out the noise word file, did you remember to leave
> a single space in it?
>
> --
> Dan
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

What can i do to use prefix search . Do i leave FTS and use like operator ?
any idea?
 >> Stay informed about: FULL TEXT SEARCH PROBLEM 

one thing you can do is to store your content in reverse from and then
reverse your search phase and do the wildcard that way, ie a search on
*phone would be searched as enohp*.

Other than that you need to do a like.

On Feb 7, 5:39 am, "in da club" <s> wrote:
> What can i do to use prefix search . Do i leave FTS and use like operator ?
> any idea?
 >> Stay informed about: FULL TEXT SEARCH PROBLEM