pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <20080207091746.GC21225@easy2.in-chemnitz.de>
Permalink:  ../20080207091746.GC21225@easy2.in-chemnitz.de/
Also on:    postgresql.org/message-id/20080207091746.GC21225@easy2.in-chemnitz.de

 · 

reply

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