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.
Problem with special characters (International Characters)
Moderators: chulett, rschirm, roy
-
Minhajuddin
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
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
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
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
MaDFroG