title: How to change the template database collection coding
body: <p>I want build new postgreSQL database by:</p>
  
  <pre><code>CREATE DATABASE newdb
  WITH OWNER = postgres
     ENCODING = 'UTF8'
     TABLESPACE = pg_default
     LC_COLLATE = 'zh_CN.UTF-8'
     CONNECTION LIMIT = -1;
  </code></pre>
  
  <p>and the error is:</p>
  
  <blockquote>
    <p>ERROR:  new collation (zh_CN.UTF-8) is incompatible with the collation of the template    database (en_US.UTF8)<br>
    HINT:  Use the same collation as in the template database, or use template0 as template.</p>
  </blockquote>
  
  <p>How to change the template database collection?</p>