Re: initdb - encoding question

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: "Josh Harrison" <joshques(at)gmail(dot)com>
Subject: Re: initdb - encoding question
Date: 2007-12-05 10:11:53
Message-ID: 200712051111.54344.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Montag, 3. Dezember 2007 schrieb Josh Harrison:
> initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data

> The database cluster will be initialized with locales
> COLLATE: en_CA.ISO8859-1
> CTYPE: en_CA.ISO8859-1
> MESSAGES: C
> MONETARY: en_CA.ISO8859-1
> NUMERIC: en_CA.ISO8859-1
> TIME: C
> initdb: encoding mismatch
> The encoding you selected (UTF8) and the encoding that the
> selected locale uses (LATIN1) do not match. This would lead to
> misbehavior in various character string processing functions.
> Rerun initdb and either do not specify an encoding explicitly,
> or choose a matching combination.
>
> Why do I get this error?

It's an encoding mismatch. The encoding you selected (UTF8) and the encoding
that the selected locale uses (LATIN1) do not match. This would lead to
misbehavior in various character string processing functions.

> How can I solve this?

Rerun initdb and either do not specify an encoding explicitly, or choose a
matching combination.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2007-12-05 10:12:37 Re: initdb - encoding question
Previous Message Marko Kreen 2007-12-05 10:08:32 Re: pgcrypto functions fail for asymmetric encryption/decryption