NLS Configuration - Oracle character set to '?'
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Any idea, guys?ray.wurlod wrote:What are the NLS settings for Oracle? Have you mapped these in DataStage? ...
Where do I need to set to extract exactly the source characters, without replace some special chars by '?' ?
I tried to set NLS options at the Administrator (Paralllel Maps): UTF-16, UTF-8, ISO-8859-10, ISO-8859-1 but none of them worked.
Any tip?
Thanks in advance.
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil
When I am extracting from Oracle, I usually find it is sufficient to take the Oracle database's NLS_LANG value and set the same thing as an environment variable at the DataStage project level in the DataStage Administrator project settings' Environment.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm