From: Peter Eisentraut <peter_e@gmx.net>
To: Jan-Peter.Seifert@gmx.de
Cc: pgsql-admin@postgresql.org
Subject: Re: server/db encoding (mix) issues
Date: Mon, 08 Sep 2008 12:40:50 +0300
Message-ID: <48C4F322.1050905@gmx.net> (raw)
In-Reply-To: <20080908085758.36590@gmx.net>
References: <20080903102701.205580@gmx.net>
<48BFE6B9.7030103@gmx.net>
<20080908085758.36590@gmx.net>
Jan-Peter.Seifert@gmx.de wrote:
> Well - I did setup two instances of 8.3.3 on an Ubuntu 7.10 system last week - both under a different user account. I set the locale for each account in the .bashrcs ("export LANG=de_DE" and "export LANG=de_DE.UTF-8" respectively). After that I ran initdb ("initdb --encoding='LATIN1' -W -A md5 -D $PGDATA" and "initdb --encoding='UTF8' -W -A md5 -D $PGDATA"(?)). I'm not sure whether I specified the server encoding for the UTF8-instance though. Did I make something wrong?
Not really, but I suggest you forget about the environment settings and
forget about the --encoding option and just use the --locale option of
initdb to set the locale settings.
> However, when I try to create an UTF-8 db in the LATIN1 server or an LATIN1 db in the UTF-8 server I get the error that the db encoding does not match the server locale and that the LC_TYPE-Locale requires the encoding of the server. Before that I thought it just fails because there is no locale with the name LATIN1 in windows. Are those additional encoding checks in v8.3.3 or had they been put in place with v8.3.1 already?
They have existed since 8.3.0.
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: peter_e@gmx.net, Jan-Peter.Seifert@gmx.de
Subject: Re: server/db encoding (mix) issues
In-Reply-To: <48C4F322.1050905@gmx.net>
* 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