Export (0) Print
Expand All

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.

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.

The following table shows values for the languages whose word breakers are registered by default.

Language

LCID

Arabic

1025

Bengali (India)

1093

British English

2057

Bulgarian

1026

Catalan

1027

Chinese (Hong Kong SAR, PRC)

3076

Chinese (Macao SAR)

5124

Chinese (Singapore)

4100

Croatian

1050

Czech

1029

Danish

1030

Dutch

1043

English

1033

French

1036

German

1031

Greek

1032

Gujarati

1095

Hebrew

1037

Hindi

1081

Icelandic

1039

Indonesian

1057

Italian

1040

Japanese

1041

Kannada

1099

Korean

1042

Latvian

1062

Lithuanian

1063

Malay - Malaysia

1086

Malayalam

1100

Marathi

1102

Neutral

0

Norwegian (Bokmål)

1044

Polish

1045

Portuguese (Brazil)

1046

Portuguese (Portugal)

2070

Punjabi

1094

Romanian

1048

Russian

1049

Serbian (Cyrillic)

3098

Serbian (Latin)

2074

Simplified Chinese

2052

Slovak

1051

Slovenian

1060

Spanish

3082

Swedish

1053

Tamil

1097

Telugu

1098

Thai

1054

Traditional Chinese

1028

Turkish

1055

Ukrainian

1058

Urdu

1056

Vietnamese

1066

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft