| From: | Michael Schuerig <michael(at)schuerig(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Ordering and unicode |
| Date: | 2005-11-10 22:18:26 |
| Message-ID: | 200511102318.26987.michael@schuerig.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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.
Yes, it is the case. Just checked on another installation. Thanks for
listening...
Michael
--
Michael Schuerig Thinking is trying to make up
mailto:michael(at)schuerig(dot)de for a gap in one's education.
http://www.schuerig.de/michael/ --Gilbert Ryle
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2005-11-10 22:24:23 | Where |
| Previous Message | Andrew Schmidt | 2005-11-10 22:08:52 | Two slightly different queries produce same results, one takes 1/4 the time.. bug in planner? |