Re: DBD::Pg && handling of UTF-8 char columns

On Fri, 11 Oct 2019, Matthias Apitz wrote:

> One special problem we face at the moment is how DBD::Pg is handling 
> UTF-8 strings in the char columns in the database. The PG server is 11.4 
> on Linux and DBD::Pg is 3.10.0-3.
[snip]
>
> The resulting column contains ISO 8859-1 data:
>
> HexStr: 50e46461676f67697363686520486f6368736368756c65205765696e67617274656e2020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020
> P<E4>dagogische Hochschule Weingarten
>
> Following the man page of DBD::Pg the attribute pg_enable_utf8  => 1
> should ensure that strings are returned from DBI with the UTF-8 flag
> switched on. The server sends the string in UTF-8 as I can see with
> strace (see the chars P\303\244dagogische...):
[snip]
>
> But why it gets translated to ISO? What do we wrong?

Hi, Matthias.

That output is from a print statement going to STDOUT, so I wonder, are 
you already telling Perl that you want UTF-8 output with something like 
this at the beginning of your script?

use open qw( :std :utf8 );

Otherwise Perl may be defaulting to writing out Latin-1.

Jon


-- 
Jon Jensen
End Point Corporation
https://www.endpoint.com/