Page 1 of 1
Posted: Mon Jul 23, 2007 9:27 am
by Minhajuddin
I tried many NLS code pages..
But it does the same...
And my backend Database is Oracle. The stage I am using is a DRS stage.
Posted: Mon Jul 23, 2007 10:27 am
by paddu
Looks like it is german character
What is your source system ?
check the NLS settings in the source and target database using
select * from V$NLS_PARAMETERS.
Try to match the NLS setting of Datastage server with that of database while loading.
Our seniors in this forum can throw more light on this.
Thanks
Paddu
Re: Problem with special characters (International Character
Posted: Mon Jul 23, 2007 11:14 pm
by Zhang Bo
i advise you to watch the hex of the record,if they are the same,then no need worry about it,the '!' you saw just a substitute that can't present properly,your system can't show it properly