Applies to master database only. syslanguages contains one row for each language known to SAP ASE. us_english is not in syslanguages, but it is always available to the SAP ASE server.
The columns for syslanguages are:
Name |
Datatype |
Description |
|---|---|---|
langid |
smallint |
Unique language ID |
dateformat |
char(3) |
Date order; for example, “dmy” |
datefirst |
tinyint |
First day of the week—1 for Monday, 2 for Tuesday, and so on, up to 7 for Sunday |
upgrade |
int |
SAP ASE version of last upgrade for this language |
name |
varchar(30) |
Official language name, for example, “french” |
alias |
varchar(30) null |
Alternate language name, for example, “français” |
months |
varchar(251) |
Comma-separated list of full-length month names, in order from January to December—each name is at most 20 characters long |
shortmonths |
varchar(119) |
Comma-separated list of shortened month names, in order from January to December—each name is at most 9 characters long |
days |
varchar(216) |
Comma-separated list of day names, in order from Monday to Sunday—each name is at most 30 characters long |
Unique clustered index on langid
Unique nonclustered index on name
Unique nonclustered index on alias