Sql Full Text Search - 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

General SQL Server Forums

New to SQL Server Programming

Sql Full Text Search

Author

Topic

amodi
Yak Posting Veteran

83 Posts

Posted - 2009-09-11 : 10:31:27

Hello friends,

I created a catalog, unique index and full text index as follows

create fulltext catalog ISFullTextCatalogDetails

create unique index ui_PagesMaster on Pages_Master(PageId)

create fulltext index on Pages_Master(Page)
Key Index ui_PagesMaster on ISFullTextCatalogDetails
with CHANGE_TRACKING MANUAL

Note: In the following

create fulltext index on Pages_Master(Page)
Key Index ui_PagesMaster on ISFullTextCatalogDetails
with CHANGE_TRACKING MANUAL

Column "Page"(where i want to search data) in Pages_Master table is of type varchar(max)

Every thing works fine, but when i search the data like:

SELECT pageId,Page,fk_pagecode FROM Pages_Master
Where contains (Page, ' "Procedures" ')
It is displaying no data???

Thanks.

amodi
Yak Posting Veteran

83 Posts

Posted - 2009-09-12 : 09:58:12

Hello friends,

I just change the column type( where i am doing data search) from varchar(max) to varchar(100)
and its working.

Does sql server FTS not support varchar(max)? or
Does sql server FTS have some limit on varchar() character? or
Do i need to change some setting of Sql Server 2005?

Thanks.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources