Re: why ORDER BY works wrong in pg7.3.4?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: root(at)osb368(dot)nnov(dot)ru
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why ORDER BY works wrong in pg7.3.4?
Date: 2003-11-24 13:33:56
Message-ID: 8928.1069680836@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

igor <root(at)osb368(dot)nnov(dot)ru> writes:
> Thank u for hint it really helped me - I made initdb with new lc-ctype
> and lc-collate
> settings : ru_RU:UTF8.
> But im still having one question - some functions - lower() and upper()
> doesnt work properly . what im doing wrong?

We don't have any support for upper() and lower() in multibyte character
encodings, such as UTF8. You need to use a single-byte encoding (and a
locale setting to match, of course).

Yeah, I know this sucks :-(. I think Peter Eisentraut is looking into
fixing it for 7.5.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Claudio Lapidus 2003-11-24 13:44:10 Re: rounding timestamps
Previous Message Tom Lane 2003-11-24 13:29:07 Re: Declaring empty, non-NULL array in plpgsql