title: Sql Server 2008 - Difference between collation types
body: <p>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.</p>
  <ol>
  <li><p>What is the difference between the Windows Collation <code>&quot;Finnish_Swedish_100&quot;</code> and <code>&quot;Finnish_Swedish&quot;</code>?</p>
  <p>I suppose that the <code>&quot;_100&quot;</code>-version is a updated collation in SQL Server 2008, but what things have changed from the older version if that is the case?</p>
  </li>
  <li><p>Is it usually a good thing to have <code>&quot;Accent-sensitive&quot;</code> enabled? I know that it depends on the task and all that, but is there any well-known pros and cons to consider?</p>
  </li>
  <li><p>The <code>&quot;Binary&quot;</code> and <code>&quot;Binary-code point&quot;</code> parameters, in which cases should theese be enabled?</p>
  </li>
  </ol>