Re: lower function - Mailing list pgsql-general

From Mage
Subject Re: lower function
Date
Msg-id 42546202.3010109@mage.hu
Whole thread Raw
In response to Re: lower function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: lower function
List pgsql-general
Tom Lane wrote:

>Mage <mage@mage.hu> writes:
>
>
>>It's serious.
>>
>>
>
>That's a Perl bug not a Postgres bug: libperl should not change the
>process's locale settings, or at least if it does it should restore
>the prior settings before returning.  It doesn't.
>
>
>
I checked with show all, client and server encoding remained latin2, and
lc_ctype remained hu_HU. However, the lower function got corrupted
(encoding) until the end of the session.

I can reproduce the bug on an Debian Sarge and on a Gentoo. Both are
up-to-date.

What should I do? Subscribe to perl list and tell about this? I have to
write a trigger which can't be written well in plpgsql. My options are
to learn python or tcl on basic level in one day. I am not sure I want
and can do this.

       Mage



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY command use UTF-8 encoding and NOT UNICODE(16bits)... please confirm. Should postgresql add :set CLIENT_ENCODING to 'UTF-8'; to avoid confusion
Next
From: Tom Lane
Date:
Subject: Re: Big trouble with memory !!