full-text catalogs, and their population

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

full-text catalogs, and their population

Author

Topic

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 03:16:52

i have maded a full-text catalog with two fields, which connects to this full-text catalog,

but for example using query with contains ussage, i cannot see any data returned by query to me,

maybe i am something missed ? for example i want to make a simple query select field
from table where contatins (col_name, 'a')

i want to make simple query how in interbase, select * from table where col_name containing 'a'

and to me are returned all rows where col_name contains character a,

this full text catalogs are populated automatically, when new rows are added ?

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-05-05 : 03:30:37

Try it with some better words. Just like Google won't search on common words like "a" or "no", a Full Text index will ignore those requests.

Damian

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 03:43:34

hm, but what is the reason of this one char search ignoring , why i cannot search all products , for example containing letter a..

also i have tried contains function with normal words that present in the table rows, but nothing

for example v.simple ex.

SELECT T,O
FROM TABLE_1
WHERE CONTAINS(T,'"product1" or "product2"')

returns to me any results, but using simple select * , i can see that all data which i am trying to search, are in database

data in rows and searched data are in the lowercase

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 03:47:08

i choose >start full population on my full-text catalog and now i can see searched data

!?, this meand, that after every new client post i must to start full population on this catalog, because if i dont start population clients cannot find the searched data ,

this is system of search catalog, is it right ?

1) client posts data
2) transaction commit
3) trigger fired , start sp = full data population on _SEARCH CATALOG

Edited by - marconi8 on 05/05/2003 04:12:33

Edited by - marconi8 on 05/05/2003 04:13:24

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 06:38:49

thanks, people i have founded some help in change tracking population

EXECUTE sp_fulltext_table TBNAME, 'start_change_tracking'
EXECUTE sp_fulltext_table TBNAME, 'start_background_updateindex'

at this moment i have problem with incremental population, strange, i have already timestamp field, but ft catalog is always populated very much time

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 07:10:28

reply to Merkin

re>Just like Google won't search on common words like "a" or "no", a Full Text index will ignore those requests.

i tried google for searching a or no, and google perfectly works , i get much of search results

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-05-05 : 07:23:35

for example

FIELD_1
-------
|ID| |NAME|
-------
1 a
2 b
3 aa
4 bb

1) user type into search edit.text = a b
2) next user.search.string is splitted, for example into array

3) after this is construed sql search condition like this

where... CONTAINS(NAME,'"a*" OR "b*"')

results will be aa (ID 3) and bb (ID 4)

why this ussage of chr * cannot show to me results of ID 1 and ID 2

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources