Chinese/Japanese - View Data issue in Datastage
Posted: Thu Dec 01, 2016 10:02 am
Hi Team,
Currently I am working on the POC to read/Write the Chinese/Japanese data from oracle table into the Target Oracle/Teradata Table and Seq File using the datastage jobs.
Source data in oracle looks good and the target data in Oracle/Teradata table also looks good. The Target file while viewing it from unix looks good.
But while i view the data in datastage either in Oracle or in seq file, the data is displayed with question mark chars '????'
Here is my NLS setting details:
Oracle:
NLS_LANGUAGE: AMERICAN
NLS_CHARCTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
Datastage:(from log file, environment variables)
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
LANG: en_US.UTF-8
Also by reading several of similar post in DSxchange, i changed the NLS setting in datastage job properties with JIS/SHIFT_JIS with NLS Locale as PROJECT OFF and ja_jp. but still am not able to view the data from datastage. Also i tried to give Unicode at column level still the same results.
Kindly help me on what settings do i need to make,to view the chinese/japanese characters from datastage.
Appreciate you help in Advance.
Thank You,
Senthil
Currently I am working on the POC to read/Write the Chinese/Japanese data from oracle table into the Target Oracle/Teradata Table and Seq File using the datastage jobs.
Source data in oracle looks good and the target data in Oracle/Teradata table also looks good. The Target file while viewing it from unix looks good.
But while i view the data in datastage either in Oracle or in seq file, the data is displayed with question mark chars '????'
Here is my NLS setting details:
Oracle:
NLS_LANGUAGE: AMERICAN
NLS_CHARCTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
Datastage:(from log file, environment variables)
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
LANG: en_US.UTF-8
Also by reading several of similar post in DSxchange, i changed the NLS setting in datastage job properties with JIS/SHIFT_JIS with NLS Locale as PROJECT OFF and ja_jp. but still am not able to view the data from datastage. Also i tried to give Unicode at column level still the same results.
Kindly help me on what settings do i need to make,to view the chinese/japanese characters from datastage.
Appreciate you help in Advance.
Thank You,
Senthil