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

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

Why Postgres allows creating UNICODE database with the locale, that
can possibly corrupt my data?