Nevermind, I'm an idiot. yeah, for latin1 you'd need locale=C On Thu, Apr 9, 2009 at 6:24 AM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Thu, Apr 9, 2009 at 6:03 AM, Bruno Baguette <bruno.baguette@xxxxxxxxx> 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 > -- When fascism comes to America, it will be the intolerant selling it as diversity. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
