From: | brian <brian(at)zijn-digital(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: initdb - encoding question |
Date: | 2007-12-03 18:01:14 |
Message-ID: | 4754446A.8030801@zijn-digital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Josh Harrison wrote:
> Hi
> Im tying to initialize the cluster using initdb and encoding 'UTF8'
> initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data
>
> But I get this error
> The files belonging to this database system will be owned by user "josh".
> This user must also own the server process.
>
> 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? How can I solve this?
> Thanks
> josh
>
ISO8859-1 is "latin 1". Try using en_CA.utf-8 instead.
brian
From | Date | Subject | |
---|---|---|---|
Next Message | John Burger | 2007-12-03 18:03:54 | Re: Will PG use composite index to enforce foreign keys? |
Previous Message | Ivan Sergio Borgonovo | 2007-12-03 17:51:48 | stored procedures and dynamic queries |