sys.syslanguages (Transact-SQL)
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 |
