Re: Will PostgreSQL 8.4 allow having different encoding databases on a same PostgreSQL server ?

On Thu, Apr 9, 2009 at 6:03 AM, Bruno Baguette <bruno.baguette@gmail.com> wrote:
> Hello !
>
> Currently, I have several PostgreSQL databases, some of them are using
> LATIN1 encoding, some of them are using UTF-8 encoding.
>
> In order to have theses two encoding, we had to install two PostgreSQL
> server on two different ports. One is for LATIN1 databases and one is for
> UTF-8 databases. (I known there is a workaround which allows to mix several
> databases encoding them on a same PostgreSQL server, by specifying "C"
> locale to initdb).

I think you are misinformed.  With pgsql 8.3:

smarlowe=# show lc_collate ;
 lc_collate
-------------
 en_US.UTF-8

 \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 smarlowe  | smarlowe | UTF8

create database test with encoding 'SQL_ASCII';
 \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 postgres  | postgres | UTF8
 smarlowe  | smarlowe | UTF8
 test      | smarlowe | SQL_ASCII