Re: [GENERAL] Postgresql 8.1: plperl code works with LATIN1, fail

2007-01-29 Thread Randal L. Schwartz
> "Michael" == Michael Fuhr <[EMAIL PROTECTED]> writes: Michael> Isn't that the situation here? The PL/Perl function body is a Michael> string encoded in the database's encoding, which in this case is Michael> UTF-8. If that's always the case, then the embedded Perl interpreter should be sta

Re: [GENERAL] Postgresql 8.1: plperl code works with LATIN1, fail

2007-01-29 Thread Michael Fuhr
On Mon, Jan 29, 2007 at 01:34:47PM +0100, [EMAIL PROTECTED] wrote: > > If you can't upgrade to 8.2 then you might be able to work around > > the problem by creating the function as plperlu and adding 'use utf8;'. > > As fas as i know 'use utf8;' normally just tells Perl that the source code > is w

Re: [GENERAL] Postgresql 8.1: plperl code works with LATIN1, fail

2007-01-29 Thread Matthias . Pitzl
> In an 8.1.6 UTF-8 database this example returns false; in 8.2.1 it > returns true. See the following commit message and the related bug > report regarding PL/Perl and UTF-8: > > http://archives.postgresql.org/pgsql-committers/2006-10/msg00277.php > http://archives.postgresql.org/pgsql-bugs/2006