$sSQL = " select japanese_longname, \n";
$sSQL .= " japanese_shortname \n";
$sSQL .= " from <table name> \n";
$sSQL .= " where instrument_id = '1301' \n";
$sSQL .= " and instrument_type = 'ST' \n";
#print("Sql i d $sSQL\n");
$dbFOX_sth=$dbFOX->prepare($sSQL);
$dbFOX_sth->execute();
if ( @row = $dbFOX_sth->fetchrow_array ) {
foreach ( @row)
{
$_ = Encode::decode_utf8( $_ );
}
( $sInstrumentNameJ, $sInstrumentShortJ ) = @row;
Here the values stored in $sInstrumentNameJ,$instrumentShortJ are passed to oracle stored procwhich is inserting into Nvarchar2 datatype columns. When we hardcode values with Ascii data like "ABC" it works fine , but for japanese data it comes as junk