title: What is the right collation to be for a PostgreSQL database which may be used in different languages?
body: <p>I have a database created by:</p>
  
  <pre><code>-- Database: adatabase
  
  -- DROP DATABASE adatabase;
  
  CREATE DATABASE adatabase
    WITH OWNER = adatabaseowner
         ENCODING = 'SQL_ASCII'
         TABLESPACE = pg_default
         LC_COLLATE = 'C'
         LC_CTYPE = 'C'
         CONNECTION LIMIT = -1;
  </code></pre>
  
  <p>These appear to be the default in my PostgreSQL 8.4 installation, which appear to be based on the default locale my Ubuntu Installation was set to.</p>
  
  <p>What are the appropriate settings I should use if I want to make the system multilingual in the future?</p>