"John" <john@nospam.com> wrote in message
news:#U1WEHCAEHA.2800@tk2msftngp13.phx.gbl...
> Hi and thanks for the tips,
>
> I indexed it with Swedish and then when I search for "stift", I correctly
> get "ritstift", "rundstift" etc. However I don't get any match on
> "tändstift" and other composite words.
>
> Is there any way to alter the dictionary for the fulltext indexer so that
it
> correctly indexes "tändstift" as a composition of "tänd" and "stift"?
>
> Regards,
> John
>
> "John Kane" <jt-kane@comcast.net> wrote in message
> news:737946df.0402251456.2cd4521@posting.google.com...
> > John,
> > You should also confirm that for your FT-enable column "article" that
> > the "Language for Word Breaker" is set to Swedish_Default (or LCID
> > 1053). You can confirm this via sp_help_fulltext_columns and it's
> > column FULLTEXT_LANGUAGE for the column "article". If this is not set
> > to the correct language (Swedish_Default) this should get you better
> > results.
> >
> > Regards,
> > John
> >
> >
> > "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:<uuRTSft#DHA.2576@tk2msftngp13.phx.gbl>...
> > > no, what you have to do is trap for the word in your query and then
> expand
> > > them to all possible word forms.
> > >
> > > IE kattmatt will be expanded to (katt matt) OR (kattmatt)
> > >
> > > "John" <john@nospam.com> wrote in message
> > > news:%23G6Uvji%23DHA.1392@tk2msftngp13.phx.gbl...
> > > > Hi,
> > > >
> > > > In Swedish it is _very_ common with so called "composite words".
> Example:
> > > > "Cat" is "katt" in Swedish. "Food" is "mat" in Swedish. Thus, "Cat
> food"
> > > is
> > > > "kattmat" in Swedish.
> > > >
> > > > Now to the question: Is there a way to have Fulltext Indexing to
> recognise
> > > > composite words so that when I search for fields containing "mat" I
> _will_
> > > > also see the fields containing "kattmat"?
> > > >
> > > > WHERE CONTAINS ( article, '"*mat*"' )
> > > >
> > > > doesn't work is seems since FTS disregards the leading *.
> > > >
> > > > Best Regards
> > > > John
> > > >
> > > >
>
>

"John Kane" <jt-kane@comcast.net> wrote in message
news:737946df.0402251456.2cd4521@posting.google.com...
> John,
> You should also confirm that for your FT-enable column "article" that
> the "Language for Word Breaker" is set to Swedish_Default (or LCID
> 1053). You can confirm this via sp_help_fulltext_columns and it's
> column FULLTEXT_LANGUAGE for the column "article". If this is not set
> to the correct language (Swedish_Default) this should get you better
> results.
>
> Regards,
> John
>
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
news:<uuRTSft#DHA.2576@tk2msftngp13.phx.gbl>...
> > no, what you have to do is trap for the word in your query and then
expand
> > them to all possible word forms.
> >
> > IE kattmatt will be expanded to (katt matt) OR (kattmatt)
> >
> > "John" <john@nospam.com> wrote in message
> > news:%23G6Uvji%23DHA.1392@tk2msftngp13.phx.gbl...
> > > Hi,
> > >
> > > In Swedish it is _very_ common with so called "composite words".
Example:
> > > "Cat" is "katt" in Swedish. "Food" is "mat" in Swedish. Thus, "Cat
food"
> > is
> > > "kattmat" in Swedish.
> > >
> > > Now to the question: Is there a way to have Fulltext Indexing to
recognise
> > > composite words so that when I search for fields containing "mat" I
_will_
> > > also see the fields containing "kattmat"?
> > >
> > > WHERE CONTAINS ( article, '"*mat*"' )
> > >
> > > doesn't work is seems since FTS disregards the leading *.
> > >
> > > Best Regards
> > > John
> > >
> > >