From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: 8.3.0, locales, and encodings
Date: Thu, 7 Feb 2008 10:17:46 +0100
Message-ID: <20080207091746.GC21225@easy2.in-chemnitz.de> (raw)
In-Reply-To: <47AA6CEE.4010406@ultimeth.com>
References: <47AA6CEE.4010406@ultimeth.com>
Hi Dean,
On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote:
> 1. The provided /etc/init.d/postgresql file seems to be part of this
> trap. Should it be changed to default the encoding to POSIX?
> 2. I want my installation to have the maximum flexibility. 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.
> 3. One of my databases is ISO-8859-1, because that's the format of the
> data I get from the US gov't. However, should I instead use the 'UTF8'
> encoding for that database, and then use a client (PSQL) encoding of
> "LATIN1", and let PostgreSQL convert the data? Pros & cons?
I'd store anything UTF8. The performance penalty should be very tiny.
> I presume this ("admin") is the proper PostgreSQL list to post this to.
Yes, it is.
HTH,
Tino.
--
www.craniosacralzentrum.de
www.spiritualdesign-chemnitz.de
Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz
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@tisc.de
Subject: Re: 8.3.0, locales, and encodings
In-Reply-To: <20080207091746.GC21225@easy2.in-chemnitz.de>
* 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