by We have a requirement to provide full-text search on both English and French
text in the same database.The text data is in different columns and
different catalogs have been created. However, when creating the indexes,
only the SQL Server installed language is used, resulting in only a single
set of noise words being applied, in this case English. Therefore, the same
noise words are applied for both English and French indexes, which creates a
problem if someone wants to search for 'The' (tea) in French for example.
I just wondered if anyone else has run across a similar problem and if
anyone has resolved it. I'm wondering if this is a serious limitation in the
full-text search support provided by Microsoft.
One solution is to replicate the database to another server that has been
installed using French and then doing the French text searches on that
server. This is probably too complex and costly for our client.
If you can help or have any comments, please send e-mail direct to