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
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.
2012年3月21日星期三
full text query problem in 2005
标签:
contains,
database,
following,
formsof,
inflectional,
microsoft,
mysql,
oracle,
privatesearchftwhere,
produce,
query,
queryselect,
server,
sql,
text
订阅:
博文评论 (Atom)
没有评论:
发表评论