International Considerations for SQL Server

Microsoft SQL Server 2005 provides product-wide support for storing and using international data, including support for Unicode, collations, special character encodings, complex scripts, and date and time formatting. The topics in this section describe using the international features of each of the primary components in SQL Server 2005.

In This Section

Topic Description

International Considerations for Databases and Database Engine Applications

Provides considerations for storing, manipulating, and programming with Unicode data and other special character encodings, date and time data, and collations.

International Considerations for Analysis Services

Describes SQL Server 2005 Analysis Services (SSAS) language features, collations and translations for analysis services objects, and translations on analysis services clients.

International Considerations for Integration Services

Explains the globalization factors to consider when using SQL Server 2005 Integration Services (SSIS), such as parsing routines across locales, setting locales for packages, using text mining with non-English languages, using fuzzy matching across languages, and performing string comparisons across languages.

International Considerations for Replication

Explains Unicode and collation considerations when using Replication.

International Considerations for Reporting Services

Describes localizing SQL Server 2005 Reporting Services (SSRS) reports and Deploying Reporting Services in a global setting.

International Considerations for Notification Services

Describes Notification Services language features and Deploying notifications in a global setting.

International Considerations for Service Broker

Describes Service Broker language feature and collation considerations.

International Considerations for Full-Text Search

Describes the global language support for Full-Text Search.

Working with Languages in the User Interface

Describes using the session language and displaying complex scripts in the user interface of the SQL Server tools.