Re: UPPER()/LOWER() and UTF-8 - Mailing list pgsql-hackers

From Alexey Mahotkin
Subject Re: UPPER()/LOWER() and UTF-8
Date
Msg-id 87n0bbf8z6.fsf@dim.w-m.ru
Whole thread Raw
In response to Re: UPPER()/LOWER() and UTF-8  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:
   TL> Alexey Mahotkin <alexm@w-m.ru> writes:   >> I'm running Postgresql 7.3.4 with ru_RU.UTF-8 locale (with   >>
UNICODEdatabase 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>
goingto 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


pgsql-hackers by date:

Previous
From: "Stephen"
Date:
Subject: Re: Experimental patch for inter-page delay in VACUUM
Next
From: Jan Wieck
Date:
Subject: Re: Experimental patch for inter-page delay in VACUUM