Japanese character does not convert correctly from Oracle 10g

[CR #539726] The Japanese character “〜”, also known as UTF-16LE: 0x5EFF, does not convert correctly from the source Oracle 10g database if you use the Oracle 10g or 11g native interfaces, or the Oracle 10g or 11g ODBC interfaces in ETL Development on Windows XP.

Workaround: In ETL Development, use the Microsoft ODBC driver for Oracle that ships with Windows XP and set the NLS_LANG environment variable for locale to “AMERICAN_AMERICA.JA16SJIS” in the registry of your ETL Development machine running on Windows XP.