Tatsuo Ishii <t-ishii@sra.co.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