Sql Server 2008 - Difference between collation types

Question

I'm installing a new SQL Server 2008 server and are having some problems getting any usable information regarding different collations. I have searched SQL Server BOL and google'ed for an answer but can't seem to be able to find any usable information.

1. What is the difference between the Windows Collation "Finnish_Swedish_100" and "Finnish_Swedish"?

   I suppose that the "_100"-version is a updated collation in SQL Server 2008, but what things have changed from the older version if that is the case?

2. Is it usually a good thing to have "Accent-sensitive" enabled? I know that it depends on the task and all that, but is there any well-known pros and cons to consider?

3. The "Binary" and "Binary-code point" parameters, in which cases should theese be enabled?

Answer 1

The _100 indicates a collation sequence new in SQL Server 2008, those with _90 are for 2005 and those with no suffix are 2000. I don't know what the differences are, and can't find any documentation. Unless you are doing linked server queries to another SQL server of a different version, I'd be tempted to go with the _100 one. Sorry I can't help with the differences.