title: Create database with UTF8 encoding
body: <p>I'd want to create database with entityframework / npgsql driver with code-first approach but also UTF encoding.</p>
  <p>In PGAdmin 3 I'm unable to change Encoding because its field is readonly</p>
  <p>This sql is being shown in PGAdmin when I select my database</p>
  <pre><code>CREATE DATABASE db
  WITH OWNER = dbuser
         ENCODING = 'LATIN2' &lt;------------
         TABLESPACE = pg_default
         LC_COLLATE = 'pl_PL'
         LC_CTYPE = 'pl_PL'
         CONNECTION LIMIT = -1;
  </code></pre>
  <p>But I want to change it from <code>LATIN2</code> to <code>UTF8</code></p>
  <p>I manually tried this:</p>
  <blockquote>
  <p>SET CLIENT_ENCODING TO 'UTF8'</p>
  </blockquote>
  <p>and</p>
  <blockquote>
  <p>show client_encoding</p>
  </blockquote>
  <p>returns</p>
  <blockquote>
  <p>client_encoding_text</p>
  <p>UTF8</p>
  </blockquote>
  <p>but despite that PGAdmin 3 still shows that this database has an encoding &quot;LATIN2&quot;</p>
  <p>and my application is receiving an exception</p>
  <blockquote>
  <p>PostgresException: 22P05: the character 0xe2889e coding &quot;UTF8&quot; does not have an equivalent in &quot;LATIN2&quot;</p>
  </blockquote>
  <p>So, how can I create db with UTF8 via Entityframework with NPSQL driver for postgre using <code>context.Database.EnsureCreated()</code>?</p>