Re: need help with utf-8

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