Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping

From: valgog <valgog(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping
Date: 2008-07-23 09:50:40
Message-ID: 494b0425-ac4c-4533-965f-f6e47553bfa0@t54g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I checked for de_DE.utf8 (created a test database with initdb) and
lower/upper is working correctly there on both 8.2 and 8.3 in
different languages

On Jul 22, 11:26 am, valgog <val(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> On Jul 21, 4:32 pm, alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (Alvaro Herrera) wrote:
>
>
>
> > Valentine Gogichashvili escribió:
>
> > > On 8.2.3 database with LC_CTYPE set to en_EN, lower() function is actually
> > > corrupting UTF8 data, lowering UTF8 control bytes... I did have a chance to
> > > check if how it works on the 8.3 as I do not have any db instance with the
> > > LC_CTYPE set to en_EN.
>
> > I don't know about Unicode case mapping, but en_EN is not a UTF8 locale
> > which is why it's corrupting the data.  Try en_EN.utf8 instead.
>
> > --
> > Alvaro Herrera                                http://www.CommandPrompt.com/
> > The PostgreSQL Company - Command Prompt, Inc.
>
> > --
> > Sent via pgsql-bugs mailing list (pgsql-b(dot)(dot)(dot)(at)postgresql(dot)org)
> > To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-bugs
>
> Will en_EN.utf8 know about German, Russian, Romanian and Dutch?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomasz Ostrowski 2008-07-23 13:07:13 Re: Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping
Previous Message valgog 2008-07-23 09:48:38 Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping