Multi-Language support for full-text searching in SQL Server 2000
Posted on 2004-09-01
I'm building an application which will store multi-language string values in my database.
I am also building a search engine based on SQL Server 2k's full-text search capabilities. I understand that full-text search results depend a lot on the language and context of the phrases.
Question is: Do I need to create a different table or DB for each language and set the default language of each DB individually, or can SQL server full-text searching support multi-language queries into a single table or DB?