Re: BUG #1060: psql encoding bug : sjis

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@postgresql.org>
Subject: [BUGS] BUG #1060: psql encoding bug : sjis
Date: Thu, 22 Jan 2004 04:53:36 -0400 (AST)
Message-ID: <20040122085336.C618BCF50EA@www.postgresql.com>

>
> The following bug has been logged online:
>
> Bug reference:      1060
> Logged by:          Hitoshi Gosen
>
> Email address:      mic-gosen@ns.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 $B%F%9%H>pJs(B($B%F%9%H(B 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
>