Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexey Mahotkin <alexm(at)w-m(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UPPER()/LOWER() and UTF-8
Date: 2003-11-04 21:52:33
Message-ID: 25344.1067982753@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

upper/lower aren't going to work desirably in any multi-byte character
set encoding.  I think Peter E. is looking into what it would take to
fix this for 7.5, but at present you are going to need to use a
single-byte encoding within the server.  (Nothing to stop you from using
UTF-8 on the client side though.)

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Jan WieckDate: 2003-11-04 21:53:32
Subject: Re: Experimental patch for inter-page delay in VACUUM
Previous:From: Dave CramerDate: 2003-11-04 21:49:19
Subject: Re: Open Sourcing pgManage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group