Re: Correct Unicode sorting depends on how initdb was run

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Nils Philippsen <nphilipp(at)redhat(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Correct Unicode sorting depends on how initdb was run
Date: 2003-08-11 14:52:59
Message-ID: 2442.1060613579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Nils Philippsen writes:
>> Hmm. I ask myself whether this is desired behaviour, too.

> No, but it will take a lot of work to fix this, such as implementing our
> own locale library.

We should, however, look into using C99-spec <wctype.h> routines where
available --- the existing logic that depends on <ctype.h> stuff cannot
work with multibyte encodings. I am not sure if this has any
user-visible effects beyond upper()/lower().

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Oscar Estevez Lopez 2003-08-11 15:10:25 Re: extract and time zones
Previous Message Donald Fraser 2003-08-11 13:08:22 ALTER TABLE table RENAME COLUMN x TO y