Re: BUG #6246: character encoding for 64 bit - Mailing list pgsql-bugs

> 12. oktober 2011 04:17


> Emne: Re: [BUGS] BUG #6246: character encoding for 64 bit
> 
> On 10/10/2011 04:20 PM, Bo wrote:
> > The following bug has been logged online:
> >
> > Bug reference:      6246
> > Logged by:          Bo
> > Email address:      bo@budget123.dk
> > PostgreSQL version: 9.1
> > Operating system:   Windows server 2008
> > Description:        character encoding for 64 bit
> > Details:
> >
> > I have just installed postgresql-9.1.1 on a windows server 2008 64
> > (from binary postgresql-9.1.1-1-windows-x64) One database is in latin1
> > encoding and when connecting to it with psql i get an error:
> 
> What's the output of the psql command:
> 
>     \l+
> 
> ?
> 
> What does "SHOW client_encoding;" report for the working and non-working
> tests?
> 
> Can you connect to the problem database "demo_" from PgAdmin III? Is it
> only psql on the Windows command line that's a problem?
> 
> What's your default codepage for your windows commandline, when you
> change nothing?
> 
> --
> Craig Ringer
> 
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make
> changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

Hi
Heres some info (and hopefully some answers)

Firstly i removed 9.1.1 and installed 9.0.5. Now it seems to work.. mostly (lugging latin1 dbs around is still no
picknick)..
But just logging into the postgres db now gives me this:

**
D:\PostgreSQL\9.0\bin>psql.exe -U postgres -d postgres
Password for user postgres:
psql (9.0.5)
WARNING: Console code page (850) differs from Windows code page (1252)        8-bit characters might not work
correctly.See psql reference        page "Notes for Windows users" for details.
 
Type "help" for help.

postgres=#
**

Standard commanline codepage is 850, previous bit is with 850 as well.
"psql -l" returns a rather long list, heres part of it:

**
demo_     | demos        | LATIN1   | C         |C     |
.....
postgres             | postgres      | UTF8     | C         |C     |
**

Client encodings:

**
D:\PostgreSQL\9.0\bin>psql.exe -U postgres -d postgres -c "show client_encoding"

Password for user postgres:client_encoding
-----------------UTF8
(1 row)

D:\PostgreSQL\9.0\bin>psql.exe -U postgres -d demo_ -c "show client_encoding"
Password for user postgres:client_encoding
-----------------LATIN1
(1 row)
**

And lastly, yes i could connect with pgadmin without problems.
Remember these examples comes from another version, but i hope its not entirely useless.

I would like to add that although solved, the command line psql is showing some quirks in the same enviroment (windows
server2008 R2 Standard). If i run scripts with psql -f it chokes on BOM discriptors in utf8 files. If i convert the
filesto windows 1252 it works fine..
 
like this (update is first word in first line, file contains no non-acsii characters):
**
psql:page_spelling.sql:1: ERROR:  syntax error at or near "update"
**

Again, i hope its usefull. 
Regards
Bo Thorbjørn Jensen