Skip site navigation (1) Skip section navigation (2)

Re: plperlu problem with utf8

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plperlu problem with utf8
Date: 2010-12-08 21:15:53
Message-ID: Pine.LNX.4.64.1012090015350.12632@sn.sai.msu.ru (view raw or flat)
Thread:
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-12-08 21:18:37
Subject: Re: Final(?) proposal for wal_sync_method changes
Previous:From: David E. WheelerDate: 2010-12-08 21:00:07
Subject: Re: Review: Extensions Patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group