Обсуждение: Full Text Search: howto manage multiple languages ?
Hi,
I have the following problem with the FTS: the database contains information in several languages. As I understand, the FTS requires to associate a language when ts_vector is created. Is there any way to make a kind of international search, without having to associate a specific language to the ts_vector ? I must admit that it's quite ambiguous, but let's imagine that you have a worldwide address repository. In that case, you can find "Rue", "Street", "Strasse" etc... which have all a low significancy.
Thanks in advance for any tips,
Cédric
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet
On Sun, 21 Mar 2010, C?dric MOULLET wrote: > Hi, > I have the following problem with the FTS: the database contains information > in several languages. As I understand, the FTS requires to associate a > language when ts_vector is created. Is there any way to make a kind of FTS doesn't needs to be asscociated with specific language ! FTS requires its configuration, which binds specific lexeme type with stack of dictionaries and this has nothing with language. > international search, without having to associate a specific language to the > ts_vector ? I must admit that it's quite ambiguous, but let's imagine that > you have a worldwide address repository. In that case, you can find "Rue", > "Street", "Strasse" etc... which have all a low significancy. This particular problem can be solved using synonym dictionary, for example. Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
Thanks for your answer,
Could you point me to documentation regarding the configuration (dictionary creation, synonym creation) of FTS and how to do it ?
Thanks,
Cédric
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet
Could you point me to documentation regarding the configuration (dictionary creation, synonym creation) of FTS and how to do it ?
Thanks,
Cédric
2010/3/22 Oleg Bartunov <oleg@sai.msu.su>
On Sun, 21 Mar 2010, C?dric MOULLET wrote:FTS doesn't needs to be asscociated with specific language ! FTS requiresHi,
I have the following problem with the FTS: the database contains information
in several languages. As I understand, the FTS requires to associate a
language when ts_vector is created. Is there any way to make a kind of
its configuration, which binds specific lexeme type with stack of dictionaries
and this has nothing with language.This particular problem can be solved using synonym dictionary, for example.international search, without having to associate a specific language to the
ts_vector ? I must admit that it's quite ambiguous, but let's imagine that
you have a worldwide address repository. In that case, you can find "Rue",
"Street", "Strasse" etc... which have all a low significancy.
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
--
Welcome to my world: http://www.cedricmoullet.com/
My Linked In profile: http://www.linkedin.com/in/cedricmoullet
Twitter: http://twitter.com/cedricmoullet