sys.syslanguages (Transact-SQL)
Contains one row for each language present in the instance of SQL Server 2005. Although U.S. English is not in syslanguages, it is always available to 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
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Compatibility Views (Transact-SQL)