Postgres Pro
Downloads
Home   >   mailing lists

Ordering and unicode - Mailing list pgsql-general

From Michael Schuerig
Subject Ordering and unicode
Date
Msg-id 200511102131.49277.michael@schuerig.de
Whole thread Raw
Responses Re: Ordering and unicode  (Michael Schuerig <michael@schuerig.de>)
Re: Ordering and unicode  (Guido Neitzer <guido.neitzer@pharmaline.de>)
List pgsql-general
Tree view 
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.

Michael

--
Michael Schuerig                       Face reality and stare it down
mailto:michael@schuerig.de        --Jethro Tull, Silver River Turning
http://www.schuerig.de/michael/

pgsql-general by date:

Previous
From: Jean-Paul Argudo
Date:
Subject: Re: Dynamic web sites with PostgreSQL
Next
From: Michael Schuerig
Date:
Subject: Re: Ordering and unicode