Skip site navigation (1) Skip section navigation (2)

BUG #2110: initdb set wrong default encoding

From: "Alexei" <kaaos(at)land(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2110: initdb set wrong default encoding
Date: 2005-12-13 13:04:35
Message-ID: 20051213130435.72121F0B2C@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2110
Logged by:          Alexei
Email address:      kaaos(at)land(dot)ru
PostgreSQL version: 8.1.1
Operating system:   Window XP SP2
Description:        initdb set wrong default encoding
Details: 

Good day!
I run initdb with --encoding=WIN1251 parameter, but
then 'psql -l' show that encoding of 'template{0,1}'
and 'postgres' databases is KOI8-R.

New databases created with KOI8-R encoding also,
unless specified by 'ENCODING' keyword, or '--encoding'
parameter.

During run of initdb no warning or error messages
printed.

It seems, that actually the encoding of 'template{0,1}' and 'postgres'
databases is valid (CP1251):
query "select ''" print ''. ( - is a symbol
present in CP1251 at code 0x00b9 and not present in KOI8-R)

But in newly created database the same query print empty space (as in KOI8-R
database), and 'psql -l' show, that ALL databases have KOI8-R encoding.

Thank you and sorry for my English.

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-12-13 15:42:43
Subject: Re: COPY TO STDOUT BINARY
Previous:From: Andreas PflugDate: 2005-12-13 12:11:28
Subject: COPY TO STDOUT BINARY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group