Hello All,
I have a sql server 2005 db which contains a full text catalog on a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as
word breakers and thus separates them out.
I have tried changing the full text language to neutral on the server
and rebuilding the db but that dint help, is it supposed to behave this
way and is there any configuration changes for this behavior ?
we are using 1033 as the language and using containstable clause to
search in a full text catalog.
thanks
Hilary Cotter - 25 Aug 2008 17:57 GMT
yes, this is by design, data-base is indexed as data, base and database.
The Dutch language has some idio syncracies with hyphenation but basically
this is the same across all languages.
> Hello All,
>
[quoted text clipped - 12 lines]
>
> thanks