Locale Table
Stores locale information, which consists of country and language combinations.
Use the LocaleCode
column as the foreign key into this table.
Database Column |
Details |
---|---|
LocaleCode
|
Type: text (max 6 characters). Key A combination of the language code and country code, separated by a hyphen. If there is no country code, then there will be no hyphen added. This column MUST have the correct value when inserted, based on the values of the language and country codes. |
LangCode3
|
Type: text (max 3 characters). Key The three letter language code. |
CountryCode
|
Type: text (max 2 characters). Key. Nullable The two letter country code. |
LocaleName
|
Type: text (max 128 characters) The name of the locale. For example, “English (United States)”. |
MSLocaleID
|
Type: integer. Nullable The Microsoft identifier for the locale. For example, 1033 for English (United States). |