Search Postgresql Archives

Re: initdb - encoding question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux