Recent posts covered collation support and Unicode in SQL Server.
Just a couple of links with more information on this topic:
- Qingsong Yao’s blog Collation, DateTime, SParse Column and XML
- especially the article on Unicode References
- Michael Kaplan’s Sorting it all Out
- his articles on SQL Server and Collations