Full-Text On SQL Express - SQL Server Forums

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 2005 Forums

Express Edition and Compact Edition (2005)

Full-Text On SQL Express

Author

Topic

staplebottom
Starting Member

29 Posts

Posted - 2007-05-09 : 23:41:00

Hi,

A couple of questions on the Full-Text feature of SQL Express.

I am currently developing a site, and am using Express as my database, though I will be using a standard version of 2005 when I get to go live. The full text on express as I understand is limited to one column per table. On sql 2005, can I index multiple columns to one collection, and then search that?

The main question i have is concerning creating a collection that works. I have created a catalog, and received no errors so that seems fine. Then I created an index, using a column which contain nvarchar data. This also seems fine. I used the templates provided to achieve all this. When I try to use the 'Start Full Population' template I get this message : 'Request to start a full-text index population on table or indexed view 'tbl_indexme_locale' is ignored because a population is currently active for this table or indexed view'.

If I execute 'SELECT * FROM sys.fulltext_indexes' there is one result, and it appears to have completed a full crawl in a manner of seconds. is_enabled =1.

The problem Im having is that when I execute a command like this :

select * from tbl_indexme_locale
where overview like '%mason%'

I get results, but the following :

SELECT *
FROM tbl_indexme_locale
WHERE CONTAINS(overview, 'mason') ;
GO

returns no records, when it obviously should. Can anyone help me with this?

Thanks,
C

staplebottom
Starting Member

29 Posts

Posted - 2007-05-10 : 10:41:46

I have realised now that there is something amiss with my search. searching for mason as per the example doesnt work, as it is part of a word. I dont understand why full text doesnt match part of a word to my search, but this is just a note for anyone else reading this. When I did a search for 'stonemason' it worked, but 'mason' did not. Weird....

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-10 : 13:23:04

Tried this:

SELECT *
FROM tbl_indexme_locale
WHERE CONTAINS(overview, '*mason') ;
GO

staplebottom
Starting Member

29 Posts

Posted - 2007-05-10 : 13:29:06

Hi Rmiao,

That should work fine, but if a user enter a search term on a site, shouldnt i expect a match if the term is part of a word, as with the like keyword?

Thanks,
C

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-10 : 13:47:54

Check books online for different search terms available.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources