SQL Server 2008 is fully aligned with the collations in Windows Server 2008.
To this end, it has 80 new collations which are denoted by *_100 version references.
The total number of variations for these collations exceeds 1400.
The purpose of this enhancement is to provide users with the most up-to-date and linguistically accurate cultural sorting conventions.
In order to see the new collations along with their variations in SQL Server 2008 you can use the following T-SQL query:
–Get new collation details
SELECT [name], [description]
FROM sys.fn_helpcollations()
WHERE [name] LIKE ‘%100%’
For more information on SQL Server 2008 Collation and Unicode Support you can check out the following link.
Artemakis Artemiou, a distinguished Senior Database and Software Architect, brings over 20 years of expertise to the IT industry. A Certified Database, Cloud, and AI professional, he earned the Microsoft Data Platform MVP title for nine consecutive years (2009-2018). As the founder of SQLNetHub and GnoelixiAI Hub, Artemakis is dedicated to sharing his knowledge and democratizing education on various fields such as: Databases, Cloud, AI, and Software Development. His commitment to simplicity and knowledge sharing defines his impactful presence in the tech community.