full text query problem in 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Xin Chen - 21 Apr 2005 11:54 GMT

I am trying to do the following query

select * from privateSearchFT
where contains
(*,'"formsof(inflectional,produce)" OR
"formsof(inflectional,produce)"',language 1033)

The problem is that it found no result although
(*,'"formsof(inflectional,produce)"',language 1033) found some results.

Also how do I specify different language LCID for different search word.
Let say I want to search the combination of a chinese word and english word
and I want to use inflectional on the english word so that +s and +ed got
found too. how do I specify that in sql?

The second question. I have a table containing chinese/english mix data, I
currently use the Chinese word breaker on the table. but I want to search
on both chinese and english (including inflectional on english) What is
the best configuration for this?

Also does specifying the LCID on the sql slow down the process since I have
a lot of chinese/english mix data.

Thank you very much for you hel...

--Xin Chen

Reply to this Message

Hilary Cotter - 22 Apr 2005 02:44 GMT

The language parameter does in general not affect performance for most
languages - however there is a slight impact with German and a more
significant impact (although still slight) while querying for the Far
East languages. There is a more significant while indexing.

It seems that you are querying on the same terms in your search phrase.
Perhaps if you tried a FreeText search which does implicit stemming
this might work better for you. You can only specify one language
parameter per contains perdicate, but you might be able to use two
contains or freetext predicates each with a different language.

Reply to this Message