From: Dean Gibson (DB Administrator) <postgresql@ultimeth.com>
To: pgsql-admin@postgresql.org
Subject: Re: 8.3.0, locales, and encodings
Date: Thu, 07 Feb 2008 08:32:39 -0800
Message-ID: <47AB32A7.6050406@ultimeth.com> (raw)
In-Reply-To: <20080207091746.GC21225@easy2.in-chemnitz.de>
References: <47AA6CEE.4010406@ultimeth.com>
<20080207091746.GC21225@easy2.in-chemnitz.de>
On 2008-02-07 01:17, Tino Schwarze wrote:
> Hi Dean,
>
> On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote:
>
>> 2. ... Should I be running INITDB w/ "-locale POSIX -E UTF8", or just "-locale POSIX" (implying "-E SQL_ASCII")? Or does it make a difference, since I always specify the desired database encoding when I "CREATE DATABASE... ENCODING '...';"?
>>
>
> AFAIK, it shouldn't make a difference. -E is just the default encoding for new databases.
>
>
Actually, "-E" also affects the encoding of the base PostgreSQL
databases. W/o "-E":
=> \l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
If I INITDB /w "-E UTF8":
=> \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8
So, the interesting question is, does the difference in the encoding of
the base databases affect performance or capability in any way?
-- Dean
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@ultimeth.com
Subject: Re: 8.3.0, locales, and encodings
In-Reply-To: <47AB32A7.6050406@ultimeth.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox