title: psql shell uses code page 850, windows uses 1252. How to solve change console code page?
body: <p>I have installed PostgreSQL, wanting to set up a new database, everything is going fine, until I am trying to use the € sign. And then I knew, that warning I get in the beginning is for a reason.</p>
  
  <p>The warning I am getting at starting up my psql shell is: </p>
  
  <pre><code>WARNING: Console code page (850) differs from Windows code page (1252)
           8-bit characters might not work correctly. See psql reference
           page "Notes for Windows users" for details.
  </code></pre>
  
  <p>So I am going to do as I am told (from <a href="http://www.postgresql.org/docs/9.2/static/app-psql.html" rel="noreferrer">PostgreSQL Documentation 9.2 - psql</a>):</p>
  
  <hr>
  
  <h2>Notes for Windows Users</h2>
  
  <p>psql is built as a "console application". Since the Windows console windows use a different encoding than the rest of the system, you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it will warn you at startup. To change the console code page, two things are necessary:</p>
  
  <ul>
  <li>Set the code page by entering <strong>cmd.exe /c chcp 1252</strong>. (1252 is a code page that is appropriate for German; replace it with your value.) If you are using Cygwin, you can put this command in <strong>/etc/profile</strong>.</li>
  <li>Set the console font to <strong>Lucida Console</strong>, because the raster font does not work with the ANSI code page.</li>
  </ul>
  
  <hr>
  
  <p>When I type the <strong>cmd.exe /c chcp 1252</strong> command I get a syntax error. So psql, doesn't recognize the command. 
  Out of desperation, I was trying to do something in cmd.exe itself, does not work either. </p>
  
  <p>I work in Windows 7 - 64Bit.</p>