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#' )
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?