Re: ERROR: conversion between UNICODE and LATIN1

On Fri, 15 Oct 2004 09:46:04 +0000, Andreas Pflug wrote:

> When does it fail? Enable sql logging for that.

LOG:  connection received: host=127.0.0.1 port=36036
LOG:  connection authorized: user=troels database=template1
LOG:  statement: SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid
          FROM pg_database WHERE datname='template1'
LOG:  statement: set client_encoding to 'UNICODE'
ERROR:  conversion between UNICODE and LATIN1 is not supported

Output of "env | grep LANG":
LANG=en_US.iso88591

I have previously used pgadmin3 on this system with the same LANG setting
without problems, but that was with PostgreSQL 7.4.

--
Greetings from Troels Arvin, Copenhagen, Denmark