Re: ERROR: conversion between UNICODE and LATIN1

[Andreas Pflug <pgadmin(at)pse-consulting(dot)de>]

Troels Arvin wrote:
> 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.

You're probably missing the appropriate conversions iso_8859_1_to_utf_8 
and utf_8_to_iso_8859_1 (i.e. you probably dropped them). On a default 
pgsql8, UNICODE<->LATIN1 is supported by default.

Regards,
Andreas