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
NLS - Unable to see Chinese characters
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 47
- Joined: Tue Sep 13, 2005 4:28 am
NLS - Unable to see Chinese characters
Kiran Kumar
-
- Premium Member
- Posts: 47
- Joined: Tue Sep 13, 2005 4:28 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.
(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.
_________________
- Susanne
- Susanne
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
Can you please advise what the NLS settings for DataStage (particularly the database connectivity stages) are?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.