Sql sever fulltext search does not return all the results

Question

I tried to use full text search for a table called "Business" in Sql sever 2008 here is the statement(the search term is in chinese)

select * from Business biz where CONTAINS(biz.*,'家具')

And the I use like statement to do the same

select * from Business where Name like '%家具%'

The Fulltext searc returns 8 results and the like search returns 9 results which is what I expected. Does anyone know what might cause this?

Answer 1

I don't know the Chinese language, so I can't say for sure, but here's my best guess.

SQL Server's fulltext searching is word based, while LIKE is looking for character patterns within a string. As an example in English, a CONTAINS search for "warn" would not find the word "forewarned", but a LIKE for '%warn%' would.