http://www.perlmonks.org?node_id=11134690


in reply to Dump data from unicode database

Issue resolved when i added ora_charset=>'AL32UTF8' in dbi->connect my $dbh = DBI->connect('dbi:Oracle:host=xx.x.x.x;service_name=shadow; port=1521;SERVER=DEDICATED',$user,$password, { PrintError => 1, RaiseError => 1, AutoCommit => 1, FetchHashKeyName => 'NAME_lc', TraceLevel => 1, ora_charset=>'AL32UTF8' }) or die "Canot create Databse Handle: $DBI::errstr() \n";