Using DataStage for conversion of chinese char
Posted: Wed Apr 16, 2003 7:30 pm
I am trying to transform and convert a set of data from MS Access to Oracle9i.
The data contains chinese characters. Seen from one of the posting here that I should use set NLS map to BIG5 or GB2312, tried both but did not work for me. I was not able to view the source data. All the chinese characters came out as "??" when I tried to view data from the ODBC stage connecting to the Access table.
However, I was able to view the chinese characters(Simplified Chinese) from MS Access program correctly.
Can anyone advise? Any help rendered is much appreciated. [:)]
The data contains chinese characters. Seen from one of the posting here that I should use set NLS map to BIG5 or GB2312, tried both but did not work for me. I was not able to view the source data. All the chinese characters came out as "??" when I tried to view data from the ODBC stage connecting to the Access table.
However, I was able to view the chinese characters(Simplified Chinese) from MS Access program correctly.
Can anyone advise? Any help rendered is much appreciated. [:)]