Export (0) Print
Expand All

sys.fulltext_languages (Transact-SQL)

Updated: 14 April 2006

This catalog view contains one row per language available for full-text indexing/querying operations. Each row provides an unambiguous representation of the available full-text linguistic resources that are registered with Microsoft SQL Server. The name or lcid can be specified in the full-text queries and full-text index DDL

Column Name Data Type Description

lcid

int

Microsoft Windows local ID for the language.

name

sysname

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

LCID Name

2052

Simplified Chinese

1028

Traditional Chinese

1030

Danish

1031

German

2057

British English

1033

English

3082

Spanish

1036

French

1040

Italian

1041

Japanese

1042

Korean

0

Neutral

1043

Dutch

1045

Polish

1046

Brazilian

2070

Portuguese

1049

Russian

1053

Swedish

1054

Thai

1055

Turkish

3076

Chinese (Hong Kong SAR, PRC)

5124

Chinese (Macau SAR)

4100

Chinese (Singapore)

ms176076.note(en-US,SQL.90).gifNote:
The following languages must be manually enabled for full-text indexing: Danish, Polish, Portuguese-Brazil, Portuguese-Portugal, Russian, and Turkish. For more information about how to enable these languages, see Knowledge Base article 908441 at Microsoft Help and Support.

Release History

14 April 2006

New content:
  • Added information about manually enabling certain languages for full-text indexing.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft