title: Character set in SQL Server 2005
body: <p>I've run this code in MySQL, and it's succeeded. But when I run it in SQL Server 2005, this error occurred:</p>
  
  <blockquote>
    <p>Incorrect syntax near the keyword
    'DEFAULT'</p>
  </blockquote>
  
  <p>This is the code:</p>
  
  <pre><code>CREATE DATABASE mydb DEFAULT CHARACTER SET utf8
  </code></pre>
  
  <p>Anyone can explain why it couldn't run successfully in SQL Server 2005.
  Thanks and sorry for my bad English!</p>