Re: initdb - encoding question

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