Postgres Pro
Downloads
Home   >   mailing lists

Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to theserver - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to theserver
Date
Msg-id 20191004142932.GA2532@elch.exwg.net
Whole thread Raw
In response to Perl DBI converts UTF-8 again to UTF-8 before sending it to theserver  (Matthias Apitz <guru@unixarea.de>)
Responses Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to theserver
List pgsql-general
Tree view 
## Matthias Apitz (guru@unixarea.de):

> my $text = "\xc3\xa4";
> print "text: ".$text."\n";

Your output is lying to you:
you need a binmode(STDOUT, ':encoding(utf8)'), which will make this print
"ä", and a utf8::decode($text), after which you get "ä". And when you
pass that $text through DBD::Pg, it will still be an "ä". And when you
change $text to "ä", it still works. Most other combinations will
either fail with "\xc3\xa4" or "ä".

Welcome to modern perl's handling of utf8. Cue "Everything is Fine" meme.

Regards,
Christoph

-- 
Spare Space

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Postgres 12: backend crashes when creating non-deterministiccollation
Next
From: Dmitry Bogatov
Date:
Subject: Unexpected plan width with foreign data wrapper