From: Geoffrey <lists@serioustechnology.com>
To: Travis Smith <tsmith@optionshouse.com>
Cc: Postgres-Admin list <pgsql-admin@postgresql.org>
Subject: Re: How is the default encoding determined
Date: Thu, 12 Jun 2008 15:20:55 -0400
Message-ID: <48517717.1020201@serioustechnology.com> (raw)
In-Reply-To: <D337038284820142B2A3196D1BFE2B47D7F03E@spswchi6mail1.peak6.net>
References: <48514CE1.8070803@serioustechnology.com>
<D337038284820142B2A3196D1BFE2B47D7F03E@spswchi6mail1.peak6.net>
Travis Smith wrote:
> This looks like what you are looking for.
>
>
>
> http://www.postgresql.org/docs/8.2/static/app-initdb.html
>
>
> The character set encoding can be set separately for a database when
> it is created. initdb determines the encoding for the template1
> database, which will serve as the default for all other databases. To
> alter the default encoding use the --encoding option. More details
> can be found in Section 21.2.
Thanks, I saw all that, what I was trying to figure out is where in the
environment does initdb determine what to set the encoding to when it's
not specified.
I ran into a problem with the wrong encoding on our database and I want
to figure out if it's because the environment is different on this box,
or if it was caused by the upgrade from 7.4 to 8.3
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
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: lists@serioustechnology.com, tsmith@optionshouse.com
Subject: Re: How is the default encoding determined
In-Reply-To: <48517717.1020201@serioustechnology.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