From: "Mark Watson" <mark.watson@jurisconcept.ca>
To: <pgsql-admin@postgresql.org>
Subject: Client_encoding
Date: Thu, 23 Dec 2010 09:14:20 -0500
Message-ID: <6031A844240C4B4984706AA66337817E@Gateway>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: Acuiq7Fe29w9TFLgT/SE/UEh67C3Qw==

Hello group,
Any suggestions as to how to fix this are greatly appreciated.
My setup is Vista, locally installed Postgres 8.4.6 in default folders =
with
db initialised as (server_encoding) UTF8, and databases created with =
default
encoding of WIN1252. My application program is behaving correctly using
libpq.dll. pgAdmin is configured with Preferences=3D>Font =3D Tahoma
windows-1252 and Query=3D>Font =3D Tahoma 9 windows-1252.

The test case:
1. Create a text file test.txt containing 1 line of 2 characters: =E9=C9 =
 (acute
accented lowercase and uppercase e, hex(E9C9), valid win1252 characters.
2.
CREATE DATABASE dbtest
  WITH OWNER =3D postgres
       ENCODING =3D 'WIN1252'
       TABLESPACE =3D pg_default
       LC_COLLATE =3D 'French_Canada.1252'
       LC_CTYPE =3D 'French_Canada.1252'
       CONNECTION LIMIT =3D -1;
3. Open query window to database dbtest and import the file test.txt...
4.
CREATE TABLE test
(
  col_descr text
)
WITH (
  OIDS=3DFALSE
);
ALTER TABLE test OWNER TO postgres;
set client_encoding =3D 'WIN1252';
COPY test FROM 'C:\\pgtemp\\test.txt' with  delimiter as '|' csv;
select * from test;
5. Results (no errors reported):
--- col_descr
-- ----------------
--                 (1 row with nothing displayed, but the length of
col_descr =3D 2)
6. If I execute the query:
set client_encoding =3D 'UTF8';
select * from test;

The correct results are displayed.

Is there a way, in PgAdmin, to to display the results when =
client_encoding
is set to WIN1252 ?

- Mark