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@gmail.com> wrote:
> 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
>
--
When fascism comes to America, it will be the intolerant selling it as
diversity.