Re: initdb - encoding question

initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data
gives this error
initdb: "en_CA.utf-8" is not a valid server encoding name

Thanks
josh

On Dec 3, 2007 1:01 PM, brian <brian(at)zijn-digital(dot)com> wrote:

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>