Query UTF-8 in the Perl scripts with DBI

vera

I no longer need help on this. The problem was that we were using an Oracle DB and missing the line "$ENV{'NLS_NCHAR'} = 'AL32UTF8';"

*******************************************************

We have a problem when UTF-8 data is queried from the database with DBI, it comes back as '???'. Things work okay when Teamsite saves and loads the same data to and from the database, and okay when the UTF-8 strings are hardcoded in the Perl, so it seems to be a problem with the DBI use. We have Perl 5.8.2 and DBI 1.38.

Can anyone share an example of successfully querying database from the DB using DBI in Teamsite 6.5? Is there anything to add to the code to make it work with UTF-8?