How many languages are supported within Full Text Search in SQL 2005?
During the deployment of new project for an application that is accessed worldwide by one of my client. Ther were looking to implement Full Text Search as well due to the nature of application. For your information SQL-FTS: SQL Server Full Text Search which allows fast and efficient querying when you have large amounts of unstructured data. The features and specially language feature of FTS will allow to perform a range of advanced searched on the text data within the database, just giving predication of CONTAINSTABLE, and FREETEXTTABLE functions that will return a list of rows that contain a word or a phrase in the columns that you are searching on.
So the obvious question was how many languages are supported within SQL 2005 FTS?
Within the SQL Server 2005 version FTS supports a large number of different languages and language characters that includes the accents. During the CTP for SQL 2005 23 languages were supported and after RTM till SP2 now only 17 languages support is included, for remaining 6 languages reference review KBA908441 article for more information. To get list the languages that are supported within your FTS environment execute select * from sys.fulltext_languages from the query editor. As usual further references on FTS are as follows:
Behavior Changes to Full-Text Search in SQL Server 2005
International Considerations for Full-Text Search
BOL information.