The document is archived and information here might be outdated
International Considerations for Databases and Database Engine Applications
SQL Server 2008 R2
SQL Server supports the storage and manipulation of multilingual data throughout the SQL Server Database Engine. Features include Unicode data types and other special encodings, date and time data types, and collations for sorts and comparisons.