title: Change encoding (collation?) of SQL Server 2008 R2 to UTF-8
body: <p>We'd like to move our Confluence system to a SQL Server 2008 R2. Now, since Confluence uses UTF-8 encoding, I'd need a database using the same encoding (I guess that's the collation?). </p>
  
  <p>There's the command </p>
  
  <pre><code>alter database confluence set collation COLLATION_NAME
  </code></pre>
  
  <p>Now, as it seems, there is no utf-8, and as I found out SQL Server uses ucs-2 which is basically the same. But I can't figure out what the collation name of ucs-2 would be? Does somebody know about that?</p>
  
  <p>Edit: I do see the difference between encoding and collation now. The Confluence <a href="https://confluence.atlassian.com/display/CONFKB/Known+Issues+For+SQL+Server%20documentation">documentation</a> suggests that I should create an schema which relies on UCS-2 (because MS SQL has missing support for UTF-8). I have looked trough the Managment Studio and I found an entry for schemas in the <strong>Security</strong> directory of the database. However, I can not figure out how to assign UCS-2 encoding to the schema. What do I have to realize this in the Managment Studio to do so (or which query should I use)?</p>