Обсуждение: PG 8.3.7 initdb -E LATIN1 fails on Windows

Hi,

Runnning:  initdb -E LATIN1 -D .....

Error: encoding mismatch

Used to run fine on 8.2.4 on the same Windows platform.

OUTPUT
===========
The database cluster will be initialized with locale English_United States.1252.

initdb: encoding mismatch
The encoding you selected (LATIN1) and the encoding that the selected locale uses (WIN1252) do not match.  This would
leadto misbehavior in various character string processing functions. 
Rerun initdb and either do not specify an encoding explicitly, or choose a matching combination.
============

Thanks

Danny Abraham

Abraham, Danny wrote:
> Hi,
>
> Runnning:  initdb -E LATIN1 -D .....
>
> Error: encoding mismatch

Right.  Try using Win1252 instead of Latin1:

initdb -E win1252 ...

Or just leave -E out entirely, since it will be picked up by default
from the locale setting anyway.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support