Re: any known DBD::pg change caused this utf8 issue?
Shaomei Liu <[email protected]> Thu, 19 Dec 2024 20:40:51 -0500
| Newsgroups | gmane.comp.db.postgresql.dbdpg |
|---|---|
| Message-ID | <CAK70g6NH-CbRRBWG+kU=Ozni3Z5L8bU-+6YWdsinckMTiSm-QQ@mail.gmail.com> |
--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 <<a href=3D"mai= lto:[email protected]">[email protected]</a>> 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'print $DBD::Pg::VER= SION'<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'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.</div><div><br></div><div>Cheers,</div><div>Greg</div><div><br></div></= div></div> </blockquote></div> --0000000000005366940629a9bdfa--