Dear All,
Question from a newbie in FTS...
I have a multi-lingual website. Users can enter text in their own language (out of 7 supported).
In that case, do I need to create 7 "fulltext indexes" (one per supported languages), using "CREATE FULLTEXT INDEX ON ....(......... LANGUAGE {lcid})", so that when looking for free text search, I will also be able to mention in which language I am querying the database?
To illustrate, if a text is entered in French, another in German and a third in Spanish, if a French speaking person is looking for something, as I know the language the user is currently using, I will run a query like "SELECT * FROM ft_table WHERE CONTAINS(*, "text to search", LANGUAGE @lcid). This way @lcid = 1036 (French), 1031 (German), 1034 (Spanish), 1033 (English)
Many thanks in advance,
Didier