Re: [HACKERS] plperl and regexps with accented characters - incompatible?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Date: 2007-11-12 16:56:28
Message-ID: 473885BC.9050001@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-patches

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-11-12 16:58:32 Re: update record with two-column primary key
Previous Message Gauthier, Dave 2007-11-12 16:56:06 Re: reverse strpos?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-12 16:56:42 Re: Simplifying Text Search
Previous Message Greg Sabino Mullane 2007-11-12 16:43:09 Re: plperl and regexps with accented characters - incompatible?

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2007-11-12 17:51:33 Re: [HACKERS] plperl and regexps with accented characters - incompatible?
Previous Message David Fetter 2007-11-12 16:54:44 Re: Hibernate Dialects for PostgreSQL