Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-19 Thread Abraham, Danny
We do need LATIN1.

The error message is:

initdb: encoding mismatch
The encoding you selected (LATIN1) and the encoding that the
selected locale uses (WIN1252) 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.

The version is 8.3.7.

It worked fine with 8.2.4


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-19 Thread Martijn van Oosterhout
On Sun, Jul 19, 2009 at 04:35:43AM -0500, Abraham, Danny wrote:
 We do need LATIN1.
 
 The error message is:
 
 initdb: encoding mismatch
 The encoding you selected (LATIN1) and the encoding that the
 selected locale uses (WIN1252) 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.

Given that WIN1252 is a superset of Latin-1, I'm not sure if this a
real problem. Does windows actually support Latin-1 only without
supporting Win-1251 at the same time?

Have a nice day,
-- 
Martijn van Oosterhout   klep...@svana.org   http://svana.org/kleptog/
 Please line up in a tree and maintain the heap invariant while 
 boarding. Thank you for flying nlogn airlines.


signature.asc
Description: Digital signature


[GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Abraham, Danny
It runs fine with WIN1252. 
The error message says something about lc_type.
Tried with various code pages: 850,1252. Nothing goes through.
Any thoughts?


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Diego Schulz
On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Dannydanny_abra...@bmc.com wrote:
 It runs fine with WIN1252.
 The error message says something about lc_type.
 Tried with various code pages: 850,1252. Nothing goes through.
 Any thoughts?


Would you care to mention the PostgreSQL version you are using?
Also, the exact copypasted error message would be handy.

regards,

diego

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


Re: [GENERAL] initdb fails on Windows with encoding=LATIN1

2009-07-18 Thread Pavel Stehule
2009/7/18 Diego Schulz dsch...@gmail.com:
 On Sat, Jul 18, 2009 at 1:47 PM, Abraham, Dannydanny_abra...@bmc.com wrote:
 It runs fine with WIN1252.
 The error message says something about lc_type.
 Tried with various code pages: 850,1252. Nothing goes through.
 Any thoughts?


 Would you care to mention the PostgreSQL version you are using?
 Also, the exact copypasted error message would be handy.

it's depend on language support installed in windows - postgresql use
system services.

try to: initdb -D ..\clusters\clusterA --locale=english_britain -E UTF8

http://docs.moodle.org/en/Table_of_locales

regards
Pavel Stehule


 regards,

 diego

 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general