I am fairly certain it is your Perl script (not DBI specifically) that
is feeding garbage to the DB. If you add `use utf8` to the top
somewhere (it is a scoped pragma) then it will have the following
effect, taken from the utf8 documentation:
Bytes in the source text that are not in the ASCII character set
will be treated as being part of a literal UTF-8 sequence. This
includes most literals such as identifier names, string constants,
and constant regular expression patterns.
after upgrading from RHEL7 to RHEL8, the utf-8 character is not
displayed properly in the DB. DB has correct utf-8 encoding set.
Unfortunately I don't know what changed from RHEL7 to RHEL8 that might
also trigger what you are seeing, but presumably the Perl version has
gone from really old to just old?
--
Mark Lawrence
