Date: Mon, 31 Jan 2000 08:06:20 +0100
From: Michael Meskes <meskes@postgresql.org>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] multibyte-support
Message-ID: <20000131080620.A1706@fam-meskes.de>
Mail-Followup-To: pgsql-interfaces@postgresql.org
References: <200001292215.XAA22239@localhost.localnet>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <200001292215.XAA22239@localhost.localnet>;
	from umehlig@uni-bremen.de on Sat, Jan 29, 2000 at 11:15:30PM
	+0100

On Sat, Jan 29, 2000 at 11:15:30PM +0100, Ulf Mehlig wrote:
> I discovered the multibyte-support of postgreSQL (the documentation is
> not easy to find ...). After re-compiling with "--with-mb" and
> "--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. 

Why exactly do you need multibyte? I use PostgreSQL for quite some time now
with German umlauts using locale de_DE and it works pretty well except thet
pgaccess does not display them.

But then you mention correct sort order, do you mean you get it to sort
a, "a (instead of writing the umlaut), b in this order instead of a, b, "a
which is ascii order? Well then I should take a look at it.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!