The following bug has been logged online:

Bug reference: 1060
Logged by: Hitoshi Gosen

Email address: mic-gosen (AT) ns (DOT) inter-mic.co.jp

PostgreSQL version: 7.4

Operating system: linux 2.4.9

Description: psql encoding bug : sjis

Details:

version 7.4.1

installation steps:

../configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster - D usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test1
----------------------------------------
client:
/usr/local/pgsql/bin/psql test1
\encoding sjis
create table テスト情å*±(テスト character(4));
\d
-----------------------------------------

the last command \d shows me a different name for the table.
I cannot access the table.





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

You need to create database "test1" with encoding EUC_JP or UNICODE.
For example:

/usr/local/pgsql/bin/createdb -E EUC_JP test1
--
Tatsuo Ishii

From: "PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org>
Subject: [BUGS] BUG #1060: psql encoding bug : sjis
Date: Thu, 22 Jan 2004 04:53:36 -0400 (AST)
Message-ID: <20040122085336.C618BCF50EA (AT) www (DOT) postgresql.com>

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match