Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping - Mailing list pgsql-bugs

From valgog
Subject Re: BUG #4319: lower()/upper() does not know about UNICODE case mapping
Date
Msg-id a25f435b-d0ff-47cf-b1f2-30fe1263bf7e@59g2000hsb.googlegroups.com
Whole thread Raw
In response to BUG #4319: lower()/upper() does not know about UNICODE case mapping  ("Valentine Gogichashvili" <valgog@gmail.com>)
List pgsql-bugs
On Jul 21, 4:32=A0pm, alvhe...@commandprompt.com (Alvaro Herrera) wrote:
> Valentine Gogichashvili escribi=F3:
>
> > On 8.2.3 database with LC_CTYPE set to en_EN, lower() function is actua=
lly
> > corrupting UTF8 data, lowering UTF8 control bytes... I did have a chanc=
e 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. =A0Try en_EN.utf8 instead.
>
> --
> Alvaro Herrera =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
=A0 =A0http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
>
> --
> Sent via pgsql-bugs mailing list (pgsql-b...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/p=
gsql-bugs

Will en_EN.utf8 know about German, Russian, Romanian and Dutch?

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Problem loading ispell affix file with apostrophes
Next
From: César Miguel Oliveira Alves
Date:
Subject: LDAP Authentication with spaces in DN