Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> BTW, I have digged into the problem which pg_client_encoding() returns
> EUC_JP even psql starts up with PGCLIENTENCODING=SJIS.
Is it still there for you in CVS tip? I cannot reproduce it:
regression=# create database euc_jp encoding 'EUC_JP';
CREATE DATABASE
regression=# \q
$ PGCLIENTENCODING=SJIS psql euc_jp
Welcome to psql 7.4devel, the PostgreSQL interactive terminal.
... yadda yadda ...
euc_jp=# \encoding
SJIS
euc_jp=# show client_encoding ;
client_encoding
-----------------
SJIS
(1 row)
euc_jp=# select pg_client_encoding() ;
pg_client_encoding
--------------------
SJIS
(1 row)
I'm still wondering if you have a postgresql.conf or environment
setting that is affecting this.
regards, tom lane