This topic has not yet been rated - Rate this topic

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

Other Resources

"Oslo" Repository Overview
"Oslo" Repository Architecture

Send comments about this topic to Microsoft.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)