I have been experiencing a full text problem when searching using CONTAINS
. I have the full text catalog accent sensitive setting set to false.
The table contains following rows:
Microsoft C#
Microsoft Visual C
Microsoft C
When I try to get "Microsoft C#" using the following query:
select name
from fulltexttable ft with (nolock)
where contains (
ft.name
,N'microsoft and c#'
)
...it yields the following results:
Microsoft Visual C
Microsoft C
I tried using different casing. It yields the different result set:
select *
from fulltexttable with (nolock)
where contains (
name
,N'microsoft and C#'
)
Result:
Microsoft C#
The second one is what I expected. I thought SQL Server performed a case insensitive search to get the data, but it seems casing affects the full text results?