Re: UPPER()/LOWER() and UTF-8

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> Alexey Mahotkin <alexm(at)w-m(dot)ru> writes:
>> I'm running Postgresql 7.3.4 with ru_RU.UTF-8 locale (with
>> UNICODE database encoding), and all is almost well, except that
>> UPPER() and LOWER() seem to ignore locale.

TL> upper/lower aren't going to work desirably in any multi-byte
TL> character set encoding.

Can you please point me at their implementation? I do not understand
why that's impossible.

TL> I think Peter E. is looking into what
TL> it would take to fix this for 7.5, but at present you are
TL> going to need to use a single-byte encoding within the server.
TL> (Nothing to stop you from using UTF-8 on the client side
TL> though.)

Thanks,

--alexm