You haven't told us yet how the oracle content is different from what you expected to get. What are you using to look at the table contents after the insert is done, and what do you see when you look at that?

It could be that you really are getting the utf8 character data into oracle correctly, but maybe you aren't seeing it as utf8 data when you pull it back out. The DBD::Oracle driver might not be setting the utf8 flag on scalar string values that come back from the database.

If that's the case, you may need to do something like:

use Encode;

# ... do whatever it takes to query for inserted text,
#  and assign the "Spanish" string from the DB to $fldvalue ...

# the string value from the DB is not flagged as utf8 in Perl,
#  so set the utf8 flag:

my $fldvalue = decode( 'utf8', $fldvalue );
[download]