International Considerations for SQL Server

SQL Server 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.

In This Section

• 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 (SSAS)
  Describes Analysis Services 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 Integration Services, 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 Reporting Services reports and Deploying Reporting Services in a global setting.

• 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.