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

El día viernes, octubre 11, 2019 a las 03:02:48p. m. -0600, Jon Jensen escribió:

> 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
> >
> > ...


> 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.

Hi Jon,

Of course the line

> > P<E4>dagogische Hochschule Weingarten

is caused by missing UTF-8 on STDOUT. But, the line with

> > HexStr: 50e464616 ...

is not and shows that the \xe4 is there. Why?

Thanks for your repl in any case.

	matthias

-- 
Matthias Apitz, ✉ [email protected], http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub