FTS not always case insensitive

Hello

I have a couple of questions about case-sensitivity. Mostly it seems to work, that mean the FTS is not case sensitive. With the following strings, FTS seems not to get the right records. I'm running sql server 2005, noise-words files are empty

I've inserted two rows with the following strings

First Row : b&c

Second Row : B&C

When running a query with contains (field1, 'b&c') or contains (field1, 'B&C'), I only get the first row. The only chance to get the second row is to run the query with contains (field1, ' "B&C" '), but FTS doesn't return the first row...

Any idea how to get both rows without enumerating all the possibilities ? Accent-sensitivity doesn't change the behaviour, tried both.

With normal words, i.e cake, microsoft, it seems to run well.

Thanks for support

Hello

I have another problem, which is probably caused by the german word breaker.

Say you have the word "Krüger", first letter is capital, you can search with a contain-clause "krüger", "Krüger" and also "Krueger", but a search for "krueger" with the first letter not a capital, while the word has a first letter as capital doesn't retrieve the row.

Umlaut processing by the word breaker is case-sensitive.

|||

Hello

Found a solution, uppercase the search conditions will retrieve the data :-)

Thought would probably interest anyone...

Regards