Re: plperlu problem with utf8
Oleg Bartunov <oleg@sai.msu.su>
From: Oleg Bartunov <oleg@sai.msu.su>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2010-12-08T21:15:53Z
Lists: pgsql-hackers
On Wed, 8 Dec 2010, David E. Wheeler wrote: > On Dec 8, 2010, at 8:13 AM, Oleg Bartunov wrote: > >> adding utf8::decode($_[0]) solves the problem: >> >> knn=# CREATE OR REPLACE FUNCTION url_decode(Vkw varchar) RETURNS varchar AS $$ >> use strict; >> use URI::Escape; >> utf8::decode($_[0]); >> return uri_unescape($_[0]); $$ LANGUAGE plperlu; > > Hrm. Ideally all strings passed to PL/Perl functions would be decoded. yes, this is what I expected. > > Best, > > David > > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83