Re: any known DBD::pg change caused this utf8 issue?

--0000000000005366940629a9bdfa
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thank you, Greg!
appreciate all the replies from this community!
I am happy to get confirmation on what caused my issue.
Happy Holidays
Shirley

On Thu, Dec 19, 2024 at 5:04=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail=
.com>
wrote:

> perl -MDBD::Pg -e'print $DBD::Pg::VERSION'
>> EL8 3.7.4
>> EL7 2.19.3
>
>
> Yep, that explains it. Version 2.19.3 was released in 2012. The next
> version, 3.0.0, made some major changes to the handling of UTF-8. As a
> matter of fact, that was one of the reasons for making a major bump to 3.=
x
> rather than releasing a 2.x
>
> Both of those versions were released over a decade ago! Version 3.7.4 was
> released in 2018.
>
> It's generally best to use the "cpanm" program or similar to install a
> newer version of DBI, DBD::Pg, etc. rather than relying on the underlying
> OS.
>
> Cheers,
> Greg
>
>

--0000000000005366940629a9bdfa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thank you, Greg!<div>appreciate all the replies from this =
community!</div><div>I am happy to get confirmation on what caused my issue=
.</div><div>Happy Holidays</div><div>Shirley</div></div><br><div class=3D"g=
mail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On =
Thu, Dec 19, 2024 at 5:04=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mai=
lto:[email protected]">[email protected]</a>&gt; wrote:<br></div><blockqu=
ote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px=
 solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">perl -MDBD::Pg -e&#39;print $DBD::Pg::VER=
SION&#39;<br>EL8 3.7.4<br>EL7 2.19.3</blockquote><div><br></div>Yep, that e=
xplains it. Version 2.19.3 was released in 2012. The next version, 3.0.0, m=
ade some major changes to the handling of UTF-8. As a matter of fact, that =
was one of the reasons for making a major bump to 3.x rather than releasing=
 a 2.x<div><br></div><div>Both of those versions were released over a decad=
e ago! Version=C2=A03.7.4 was released in 2018.<div><br></div><div>It&#39;s=
 generally best to use the &quot;cpanm&quot; program or similar to install =
a newer version of DBI, DBD::Pg, etc. rather than relying on the underlying=
 OS.</div><div><br></div><div>Cheers,</div><div>Greg</div><div><br></div></=
div></div>
</blockquote></div>

--0000000000005366940629a9bdfa--