• Article

sys.fulltext_languages (Transact-SQL)

This catalog view contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language. When word breakers are registered for a language, its other linguistic resources—stemmers, noise words (stopwords), and thesaurus files—become available to full-text indexing/querying operations. The value of name or lcid can be specified in the full-text queries and full-text index Transact-SQL statements.

Note

The word breakers for most languages are registered by default. However, a number of licensed third-party word breakers are disabled by default. For information about these languages and how to register these word breakers, see How to: Load Licensed Third-Party Word Breakers.

Column

Data type

Description

lcid

int

Microsoft Windows locale identifier (LCID) for the language.

name

sysname

Is either the value of the alias in sys.syslanguages corresponding to the value of lcid or the string representation of the numeric LCID.

Values Returned for Default Languages

The following table shows values for only the languages whose word breakers are registered by default. For a list of the names and LCIDs for languages whose word breakers that are disabled by default, see "Values for Languages of Third-Party Word Breakers," later in this topic.

Language

LCID

Arabic1

1025

Bengali1

1093

Brazilian

1046

British English

2057

Bulgarian1

1026

Catalan1

1027

Chinese (Hong Kong SAR, PRC)

3076

Chinese (Macau SAR)

5124

Chinese (Singapore)

4100

Croatian1

1050

Dutch

1043

English

1033

French

1036

German

1031

Gujarati1

1095

Hebrew1

1037

Hindi1

1081

Icelandic1

1039

Indonesian1

1057

Italian

1040

Japanese

1041

Kannada1

1099

Korean

1042

Latvian1

1062

Lithuanian1

1063

Malay - Malaysia1

1086

Malayalam1

1100

Marathi1

1102

Neutral

0

Norwegian (Bokmål)1

1044

Portuguese

2070

Punjabi1

1094

Romanian1

1048

Russian

1049

Serbian (Cyrillic)1

3098

Serbian (Latin)1

2074

Simplified Chinese

2052

Slovak1

1051

Slovenian1

1060

Spanish

3082

Swedish

1053

Tamil1

1097

Telugu1

1098

Thai

1054

Traditional Chinese

1028

Ukrainian1

1058

Urdu1

1056

Vietnamese1

1066

1 Support for this language was added in SQL Server 2008.

Values for Languages of Third-Party Word Breakers

The following table lists the values that are returned for third-party word breakers, if registered.

LCID

Name

1030

Danish

1045

Polish

1055

Turkish

To use the word breakers for these languages, you must register them manually. For more information about how to enable these languages, see How to: Load Licensed Third-Party Word Breakers.

Remarks

SQL Server 2008 includes word breakers for approximately 50 languages, of which 23 also exist in SQL Server 2005. Only the word breakers for English, Korean, Thai, and Chinese (all forms) remain the same. For the other languages, SQL Server 2008 introduces a new generation of word breakers that work substantially better than their SQL Server 2005 equivalents. Potentially, the new word breakers might behave slightly differently from SQL Server 2005 word breakers.  For information about updating word breakers after importing a SQL Server 2005 full-text index, see Word Breakers and Stemmers.

To create a noise word (stopword) list for a language, the language be registered with SQL Server.

Thesaurus files are automatically loaded by full-text queries that use the thesaurus. To avoid this first-time performance impact on full-text queries, we recommend that you execute sp_fulltext_load_thesaurus_file.

To update the list of languages registered with full-text search, use sp_fulltext_service 'update_languages'.

Permissions

In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.