Share via


System.Globalization Schema

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Provides support for localized strings and resources.

Data Types (UDTs)

Type Description

LocaleId

A string locale identifier that represents a particular language.

ResourceId

A GUID identifier for localized resources.

StringId

A GUID identifier for localized strings.

Views

View Description

Locales

Stores properties for all locales available to localized strings and resources.

Resources

Stores localized resources, such as icons or bitmaps. The same resource identifier appears multiple times for each language in which it is localized.

Strings

Stores localized strings. The same string identifier appears multiple times for each language in which it is localized.

Procedures

Procedure Description

FormatString

Returns a formatted string based on the string template and substitution strings.

Functions

Function Description

FormatString1

Returns a formatted string based on the string template and one substitution string.

FormatString10

Returns a formatted string based on the string template and 10 substitution strings.

FormatString2

Returns a formatted string based on the string template and two substitution strings.

FormatString3

Returns a formatted string based on the string template and three substitution strings.

FormatString4

Returns a formatted string based on the string template and four substitution strings.

FormatString5

Returns a formatted string based on the string template and five substitution strings.

FormatString6

Returns a formatted string based on the string template and six substitution strings.

FormatString7

Returns a formatted string based on the string template and seven substitution strings.

FormatString8

Returns a formatted string based on the string template and eight substitution strings.

FormatString9

Returns a formatted string based on the string template and nine substitution strings.

LocalesResource

Returns the best matching localized resource, or null if there is no match.

LocalesString

Returns the best matching localized string, or null if there is no match.

SessionsLocale

Returns the locale identifier for the current database session. This information is used by the [System.Globalization].[SessionsResource] and [System.Globalization].[SessionsString] functions.

SessionsResource

Returns the best matching localized resource for the current database session, or null if there is no match.

SessionsString

Returns the best matching localized string for the current database session, or null if there is no match.

Tables

Table Description

LocalesTable

Stores properties for all locales available to localized strings and resources.

ResourcesTable

Stores localized resources, such as icons or bitmaps. The same resource identifier appears multiple times for each language in which it is localized.

StringsTable

Stores localized strings. The same string identifier appears multiple times for each language in which it is localized.

Remarks

See Also

Other Resources

"Oslo" Repository Overview
"Oslo" Repository Architecture

Send comments about this topic to Microsoft.