Skip site navigation (1) Skip section navigation (2)

Re: How is the default encoding determined

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: Travis Smith <tsmith(at)optionshouse(dot)com>
Cc: Postgres-Admin list <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How is the default encoding determined
Date: 2008-06-12 19:20:55
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Travis Smith wrote:
> This looks like what you are looking for.
> 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

In response to

pgsql-admin by date

Next:From: timalou2Date: 2008-06-13 09:33:08
Subject: Restore a backup into a new schema
Previous:From: Travis SmithDate: 2008-06-12 16:26:12
Subject: Re: How is the default encoding determined

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group