title: Database encoding VisualStudio
body: <p>How do I change encoding of my database ? Project is NET.CORE 2.1</p>
  
  <p>I tried :</p>
  
  <pre><code>ALTER DATABASE DBNAME CHARACTER SET utf8 COLLATE utf8_general_ci;
  </code></pre>
  
  <p>But VisualStudio did not accept that command, due to syntax Error</p>
  
  <p>The second thing I tried was to change <em>appsetting.json</em> by adding <code>Charset=utf8</code> to <em>ConnectionString</em>.</p>
  
  <p>That did not work either. VisualStudio could not work out <em>Charset keyword</em>.</p>
  
  <p>Are there any other ways to do that ? Or is there any mistake in my command ?</p>
  
  <p>Command :
  <a href="https://i.stack.imgur.com/WVoEZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WVoEZ.png" alt="enter image description here"></a></p>