NLS - Unable to see Chinese characters

kiranh_1214 · Post by **kiranh_1214** » Wed Sep 28, 2011 4:10 am

I will be reading the data from an Oracle DB and loading into DB2 table

From the source one of column data receiving as chinese character and try to load the data into DB2 table , but data has been loaded with some ????????????

Here is the complete details

Source DB: Oracle
Column : TITLE
data type : NVARCHAR (255)

I am try to View Data from source oracle enterprise stage , still I am able to view Chinese character as '????"

Target DB : DB2
Column: TIT_DESC
data type: Varchar 254

After loading the data into DB2 table still i am able to view Chinese character as '?????'

DB2 NLS Setting is below:

Database territory = US
Database code page = 1208
Database code set = UTF-8

I try to use job parameter $DB2-CODE_PAGE=1208, still same issue not resolved.

Could you please guide me as to what is wrong in process

kiranh_1214 · Post by **kiranh_1214** » Wed Sep 28, 2011 4:11 am

Source data as 上海嘉华中心支行--*G* 安装保宝系统

suse_dk · Post by **suse_dk** » Wed Sep 28, 2011 6:51 am

If you look into your Oracle DB - then how does your source data appear?
(if you have a lot of ??? there I guess you know why you have it in your target also)

Speciel characters are many times not viewable using the "view" function in datastage. Try to output the result to a flat file and view it there.

And... What is the NLS setting in your job? You'll need to have a setting that support the chinese characters.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 28, 2011 4:23 pm

I would suspect that the database territory US that you've specified for DB2 would have trouble with Chinese characters.

Can you please advise what the NLS settings for DataStage (particularly the database connectivity stages) are?