Re: Client_encoding - Mailing list pgsql-admin

From Mark Watson
Subject Re: Client_encoding
Date
Msg-id 27B1EE4F2F5748E39FF0721A49B288EF@Gateway
Whole thread Raw
In response to Client_encoding  ("Mark Watson" <mark.watson@jurisconcept.ca>)
List pgsql-admin
Hello again,
Problem below solved if in fact PgAdmin only displays UTF8.

----------------------------------------------------------------
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=>Font = Tahoma
windows-1252 and Query=>Font = Tahoma 9 windows-1252.

The test case:
1. Create a text file test.txt containing 1 line of 2 characters: éÉ  (acute
accented lowercase and uppercase e, hex(E9C9), valid win1252 characters.
2.
CREATE DATABASE dbtest
  WITH OWNER = postgres
       ENCODING = 'WIN1252'
       TABLESPACE = pg_default
       LC_COLLATE = 'French_Canada.1252'
       LC_CTYPE = 'French_Canada.1252'
       CONNECTION LIMIT = -1;
3. Open query window to database dbtest and import the file test.txt...
4.
CREATE TABLE test
(
  col_descr text
)
WITH (
  OIDS=FALSE
);
ALTER TABLE test OWNER TO postgres;
set client_encoding = '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 = 2)
6. If I execute the query:
set client_encoding = '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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
________________________________________
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1170 / Virus Database: 426/3333 - Release Date: 12/23/10


pgsql-admin by date:

Previous
From: "Mark Watson"
Date:
Subject: Client_encoding
Next
From: Guillaume Lelarge
Date:
Subject: Re: Client_encoding