Full Text Search: howto manage multiple languages ?

Started by Cédric MOULLETover 16 years ago3 messagesgeneral
Jump to latest
#1Cédric MOULLET
cedric.moullet@gmail.com

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

#2Oleg Bartunov
oleg@sai.msu.su
In reply to: Cédric MOULLET (#1)
Re: Full Text Search: howto manage multiple languages ?

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

#3Cédric MOULLET
cedric.moullet@gmail.com
In reply to: Oleg Bartunov (#2)
Re: Full Text Search: howto manage multiple languages ?

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

2010/3/22 Oleg Bartunov <oleg@sai.msu.su>

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/&lt;http://www.sai.msu.su/%7Emegera/&gt;
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