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:
(two examples, one working and one not. postgres db is in utf8)
**********************************
D:\>d:\PostgreSQL\9.1\bin\psql.exe -d postgres -U postgres -c "comment on
database demo_ is 'test'"
Password for user postgres:
COMMENT
D:\>d:\PostgreSQL\9.1\bin\psql.exe -d demo_ -U postgres -c "comment on
database demo_ is 'test'"
Password for user postgres:
psql: FATAL: conversion between WIN1252 and LATIN1 is not supported
*****************************
No matter what codepage the console is set to (with chcp). Default was 850,
i have tried 1252, 28591 and 65001.
I have the exact same setup on a windows xp 32 bit without this issue. So im
guessing it has to do with the 64 bit version of psql..
Thanks for any light you can shed on this.
In any case i hope you can use this report.
Regards Bo TJ