Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

Re^11: Japanese character in Linux

by andal (Friar)
on Jul 11, 2011 at 23:30 UTC ( #913807=note: print w/ replies, xml ) Need Help??

in reply to Re^10: Japanese character in Linux
in thread Japanese character in Linux

Well, I would consider using "Encode::decode_utf8" very wrong here. At least from your previous messages it followed, that the data inserted into database was in UTF-16 encoding, so when you apply "decode_utf8" function to it, you create a mess and nothing else. Of course this function does not hurt any of pure ASCII data.

You should use "Encode::decode("UTF-16", $_)".

Comment on Re^11: Japanese character in Linux
Re^12: Japanese character in Linux
by Anonymous Monk on Jul 14, 2011 at 12:31 UTC

    We have resolved the issue Following changes were done in perl Loader to handle Japanese. Env variable setting :

    $ENV{'NLS_NCHAR'} = 'AL32UTF8';

    Encoding from Shift JIS to UTF8 after data is fetched from Sybase:

    Encode::from_to($sInstrumentNameJ, "shiftjis", "utf8"); #added for te +sting Encode::from_to($sInstrumentShortJ, "shiftjis", "utf8"); #added for t +esting

    Binding Japanese data parameters to be passed as below

    use DBD::Oracle qw(:ora_types ORA_OCI SQLCS_NCHAR ); $dbGOSTky_sth->bind_param(":sInstrumentNameJ",$sInstrumentNameJ,{ora_c +sform => SQLCS_NCHAR}); $dbGOSTky_sth->bind_param(":sInstrumentShortJ",$sInstrumentShortJ,{ora +_csform => SQLCS_NCHAR});

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://913807]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2015-04-01 01:59 GMT
Find Nodes?
    Voting Booth?

    When putting a smiley right before a closing parenthesis, do you:

    Results (677 votes), past polls