| From: | Michael Schuerig <michael(at)schuerig(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Ordering and unicode |
| Date: | 2005-11-10 20:31:48 |
| Message-ID: | 200511102131.49277.michael@schuerig.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)iso885915(at)euro(dot) 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(at)schuerig(dot)de --Jethro Tull, Silver River Turning
http://www.schuerig.de/michael/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikael Carneholm | 2005-11-10 20:40:52 | Partitioning functions |
| Previous Message | Carlos Oliva | 2005-11-10 20:02:25 | Re: Performance of autovacuum and full vacuum of database |