CONTAINSTABLE with wildcard works different in SQL Server 2005 and SQL Server 2008?
Posted
by musuk
on Stack Overflow
See other posts from Stack Overflow
or by musuk
Published on 2010-06-17T05:15:40Z
Indexed on
2010/06/17
5:43 UTC
Read the original article
Hit count: 310
I have two same databases one on SQL Server 2005 and one on SQL Server 2008, it have same SQL_Latin1_General_CP1_CI_AS Collation, and full text search catalogs have the same settings.
These two databases contains table with same data, NTEXT string: "...kræve en forklaring fra miljøminister Connie Hedegaard.."
My problem is:
CONTAINSTABLE on SQL Server 2008 finds nothing if query is:
select * from ContainsTable(SearchIndex_7, Content, '"miljø*"') ct
but SQL Server 2005 works perfectly and finds necessary record.
SQL Server 2008 finds necessary record if query is:
select * from ContainsTable(SearchIndex_7, Content, '"milj*"') ct
or
select * from ContainsTable(SearchIndex_7, Content, '"miljøminister"')
What can be reason for so strange behavior?
© Stack Overflow or respective owner