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
