5

I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.

The table contains the following entries:

  • Müller - Muller - Mueller
  • Luginbühl - Luginbuhl - Luginbuehl

Executing following search

SELECT * FROM dbo.Search WHERE CONTAINS(CNameCombined, 'FORMSOF (INFLECTIONAL,  "Mueller")')

I get these results: Müller, Muller, Mueller

Executing a similar search

SELECT * FROM dbo.Search WHERE CONTAINS(CNameCombined, 'FORMSOF (INFLECTIONAL,  "Luginbuehl")')

I get zero results.

Does anyone have an idea what the reason for this behavior might be? It seems to work for some words, but not for all of them.

I'm running a SQL Server 2012 on a Windows Server 2012.

  • When you set the collation type did you re-load the data? Collation changes don't affect extant data. – swasheck Jun 27 '13 at 14:35
1

I think all you need to know is listed here http://technet.microsoft.com/en-us/library/ms142509.aspx Look for the right languages in the index and the query parser (http://technet.microsoft.com/en-us/library/ms142583.aspx#Additional_Considerations). ...and check/post your params

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.