Re: Ordering and unicode - Mailing list pgsql-general

From Michael Schuerig
Subject Re: Ordering and unicode
Date
Msg-id 200511102318.26987.michael@schuerig.de
Whole thread Raw
In response to Ordering and unicode  (Michael Schuerig <michael@schuerig.de>)
List pgsql-general
On Thursday 10 November 2005 21:31, Michael Schuerig wrote:
> I have a database on PostgreSQL 8.0.3 with unicode (utf-8) encoding,
> client encoding is set to unicode, too. LC_COLLATE for the cluster is
> de_DE.iso885915@euro. I noticed that that collation doesn't work for
> two-byte characters, apparently they are ordered bytewise.
>
> My current conjecture is that I'd have to re-initialize the cluster
> with a utf-8 collation. Is this correct? Right now I don't have
> access to the machine and can't check this.

Yes, it is the case. Just checked on another installation. Thanks for
listening...

Michael

--
Michael Schuerig                          Thinking is trying to make up
mailto:michael@schuerig.de                for a gap in one's education.
http://www.schuerig.de/michael/                          --Gilbert Ryle

pgsql-general by date:

Previous
From: Michael Schuerig
Date:
Subject: Ordering and unicode
Next
From: Bob Pawley
Date:
Subject: Where