Contains one row for each language present in the instance of SQL Server.
|
Column name
|
Data type
|
Description
|
|---|
|
langid
|
smallint
|
Unique language ID.
|
|
dateformat
|
nchar(3)
|
Date order, for example, DMY.
|
|
datefirst
|
tinyint
|
First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.
|
|
upgrade
|
int
|
Reserved for system use.
|
|
name
|
sysname
|
Official language name, for example, Français.
|
|
alias
|
sysname
|
Alternative language name, for example, French.
|
|
months
|
nvarchar(372)
|
Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.
|
|
shortmonths
|
varchar(132)
|
Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.
|
|
days
|
nvarchar(217)
|
Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.
|
|
lcid
|
int
|
Microsoft Windows locale ID for the language.
|
|
msglangid
|
smallint
|
Database Engine message group ID.
|
The Database Engine contains the following installed languages.
|
Name in English
|
Windows LCID
|
Database Engine message group ID
|
|---|
|
English
|
1033
|
1033
|
|
German
|
1031
|
1031
|
|
French
|
1036
|
1036
|
|
Japanese
|
1041
|
1041
|
|
Danish
|
1030
|
1030
|
|
Spanish
|
3082
|
3082
|
|
Italian
|
1040
|
1040
|
|
Dutch
|
1043
|
1043
|
|
Norwegian
|
2068
|
2068
|
|
Portuguese
|
2070
|
2070
|
|
Finnish
|
1035
|
1035
|
|
Swedish
|
1053
|
1053
|
|
Czech
|
1029
|
1029
|
|
Hungarian
|
1038
|
1038
|
|
Polish
|
1045
|
1045
|
|
Romanian
|
1048
|
1048
|
|
Croatian
|
1050
|
1050
|
|
Slovak
|
1051
|
1051
|
|
Slovene
|
1060
|
1060
|
|
Greek
|
1032
|
1032
|
|
Bulgarian
|
1026
|
1026
|
|
Russian
|
1049
|
1049
|
|
Turkish
|
1055
|
1055
|
|
British English
|
2057
|
1033
|
|
Estonian
|
1061
|
1061
|
|
Latvian
|
1062
|
1062
|
|
Lithuanian
|
1063
|
1063
|
|
Brazilian
|
1046
|
1046
|
|
Traditional Chinese
|
1028
|
1028
|
|
Korean
|
1042
|
1042
|
|
Simplified Chinese
|
2052
|
2052
|
|
Arabic
|
1025
|
1025
|
|
Thai
|
1054
|
1054
|
See Also