Re: BUG #5010: perl iconv function returns ? character - Mailing list pgsql-bugs

Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Aug 25, 2009 at 8:15 AM, Lampa<lampacz@gmail.com> wrote:
>> function my_ascii2 is defined:
>> CREATE FUNCTION my_ascii2(text) RETURNS text AS $$ use strict; use
>> Text::Iconv; my $conv = Text::Iconv->new("UTF8", "ASCII//TRANSLIT"); return
>> $conv->convert($_[0]); $$ LANGUAGE plperlu;
>>
>> 8.3.x version works perfectly, 8.4.0 problem

> I can't reproduce this on 8.4.0 or CVS HEAD.  I think that whatever
> problem you have here is not a PostgreSQL bug.

I suspect that function will only work as desired in a database with
UTF8 server_encoding.  Maybe the problem is the 8.4 database is set up
with some other encoding?

            regards, tom lane