title: PostgreSQL: varchar(1) and Umlaut
body: <p>I have a <code>VARCHAR(1)</code> field in postgresql.
  Now I export data from a postgresql 9.4 server with <code>pg_dump</code>
  and import it to a postgresql 9.5 server with pgsql.</p>
  
  <p>When I import it, I get an error:</p>
  
  <blockquote>
    <p>ERROR:  value too long for type character varying(1) COPY XXX "Ö"</p>
  </blockquote>
  
  <p>That means in the table there is the value <code>"Ö"</code> which takes 2 bytes instead of 1 byte.</p>
  
  <ul>
  <li><p>Must I increase the column to <code>VARCHAR(2)</code>?</p></li>
  <li><p>Is there another way to keep <code>VARCHAR(1)</code> and use a locale etc.?</p></li>
  <li><p>Why could this data ever be stored there?</p></li>
  </ul>
  
  <p>Thanks for your help!</p>