Re: [HACKERS] plperl and regexps with accented characters - incompatible? - Mailing list pgsql-general

From Andrew Dunstan
Subject Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Date
Msg-id 473885BC.9050001@dunslane.net
Whole thread Raw
In response to Re: plperl and regexps with accented characters - incompatible?  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: [HACKERS] plperl and regexps with accented characters - incompatible?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-general


Greg Sabino Mullane wrote:
>
> Yes, we might want to consider making utf8 come pre-loaded for plperl. There
> is no direct or easy way to do it (we don't have finer-grained control than
> the 'require' opcode), but we could probably dial back restrictions,
> 'use' it, and then reset the Safe container to its defaults. Not sure what
> other problems that may cause, however. CCing to hackers for discussion
> there.
>
>
>

UTF8 is automatically on for strings passed to plperl if the db encoding
is UTF8. That includes the source text. Please be more precise about
what you want.

BTW, the perl docs say this about the utf8 pragma:

       Do not use this pragma for anything else than telling Perl that your
       script is written in UTF-8.

There should be no need to do that - we will have done it for you. So
any attempt to use the utf8 pragma in plperl code is probably broken anyway.

cheers

andrew





pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: reverse strpos?
Next
From: "Scott Marlowe"
Date:
Subject: Re: update record with two-column primary key