To: umehlig@uni-bremen.de
Cc: pgsql-interfaces@postgreSQL.org, mitja@mail.velenje.cx
Subject: Re: [INTERFACES] multibyte-support
In-Reply-To: Your message of "Sat, 29 Jan 2000 23:15:30 +0100"
	<200001292215.XAA22239@localhost.localnet>
References: <200001292215.XAA22239@localhost.localnet>
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-Id: <20000130094624Q.t-ishii@sra.co.jp>
Date: Sun, 30 Jan 2000 09:46:24 +0900
From: Tatsuo Ishii <t-ishii@sra.co.jp>
Lines: 43

> not easy to find ...). After re-compiling with "--with-mb" and

Sorry for the inconvenience. I would like to write docs for the
multi-byte support in PostgreSQL for the next release.

> "--enable-locale", re-creating the data directory with "initdb -e
> LATIN1" and re-building my database with "-e LATIN1" as well, I'm able
> e.g. to get +-proper sorting of strings with German umlauts
> etc. 
> 
> However, when I try to use the precompiled psql client for Windows
> from "ftp://ftp.postgresql.org" over a network connection, it is not

I am not sure the binary being compiled with mb. 

> able to understand the "special" characters like "u umlaut" etc.,
> whether I set CLIENT_ENCODING to either 'WIN', 'ALT', or 'LATIN1' (I
> think, multibyte support is compiled in the client, at least my unix
> psql won't let me set this variable if it has no mb). 

Sounds strange. I assume you use "set client encoding to 'LATIN1'" or
something like that. It is just a query for psql, since psql doesn't
parse the contents of the query, it should be possible for non-mb psql
to send the query.

Anyway, to make sure that you are using mb enabled psql, start
postmaster with "-d 3" flag to get debug output (turn off -
S. otherwise debug out will not appear). You should get lots of
messages including following portions:

query: select getdatabaseencoding()
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: SET client_encoding = 'LATIN1'
ProcessUtility: SET client_encoding = 'LATIN1'

If not, you gotta into trouble. You need to build mb enabled psql on
PC by yourself. Unfortunately I cannot make it for you, since I have
very little knowledges about Windows. Maybe Hiroki Kataoka have some
suggestions...
--
Tatsuo Ishii