Hi,
I have a simple ETL flow.
ODBC Stage--------> ORA Stage
The source has a special character(similar to ' ) which is read by ODBC stage but being replaced by a reverse question mark symbol in the target by the Oracle stage.
How to avoid this?
Thanks in advance.
Deepa
Special character being ignored by Oracle Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 95
- Joined: Thu Sep 24, 2009 12:15 am
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Find out what the character actually is and whether it is correctly handled by the locale and map you are using for DataStage, then make sure that the NLS_LANG setting for Oracle is compatible.
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.
Craig's answer is correct - you must set the character set correctly for BOTH the incoming data and the outgoing data. It is highly doubtful that you can change the Oracle map to UTF8 if that isn't the default, the "ripple effect" of changing the map could be significant. In the US we get spoiled because the default of UTF8 works for the basic US characters.
Please note, that setting both correctly does not insure that the character will be mapped. It may be a case where the character in the source map does not have an equivalent character in the target map. In those cases you'll need to either live with the "?" or manually parse the incoming field and replace the offending characters (something I've had to do at several sites).
Please note, that setting both correctly does not insure that the character will be mapped. It may be a case where the character in the source map does not have an equivalent character in the target map. In those cases you'll need to either live with the "?" or manually parse the incoming field and replace the offending characters (something I've had to do at several sites).