patternsqlModerate
What's the meaning of the Collation Code (blank, 90, 100, 110) in SQL Server 2012
Viewed 0 times
meaningthe2012whatserversqlblank110100collation
Problem
During the installation of SQL Server 2012, in the Collation tab, i can choose between French_CI_AS and French_100_CI_AS.
What do they mean and which one is newer? When there's no Code, is it newer or older than the 100?
What do they mean and which one is newer? When there's no Code, is it newer or older than the 100?
Solution
The one without the code is a version 90 (SQL Server 2005) collation, used by previous versions of Windows / SQL Server. The collation including 100 is newer (SQL Server 2008).
There's a bit of an overview of the differences in the SQL Server 2008 documentation, here, however it doesn't go into great detail.
If you're developing a new application, you may find that sorting is slightly more logical (particularly for unusual characters) with the 100 version. However, if you've got any other SQL Servers running with French_CI_AS, it might be better to keep it consistent with them.
There's a bit of an overview of the differences in the SQL Server 2008 documentation, here, however it doesn't go into great detail.
If you're developing a new application, you may find that sorting is slightly more logical (particularly for unusual characters) with the 100 version. However, if you've got any other SQL Servers running with French_CI_AS, it might be better to keep it consistent with them.
Context
StackExchange Database Administrators Q#41476, answer score: 15
Revisions (0)
No revisions yet.