Character Ã‚ converted to A

ArndW · Post by **ArndW** » Wed Jul 29, 2009 6:16 am

Debug it by checking the value of that string at each stage of the process to discover which component seems to be doing the modification.

ArndW · Post by **ArndW** » Thu Jul 30, 2009 2:32 am

The DataStage "View Data" facility has caused more perceived NLS problems than any other part of the tool - it is not capable of correctly displaying NLS data and shouldn't be used to see if NLS is working or not. Did you "view data" to see the character or use another tools?

ArndW · Post by **ArndW** » Thu Jul 30, 2009 2:57 am

When you read from Oracle into DataStage you need to specify the correct NLS map - the one Oracle is actually using. The same needs to be done when writing to your target. If either one of these settings is not done correctly then it is possible that characters don't get mapped the way you expect.
What are your Oracle source settings?

bakul · Post by **bakul** » Thu Jul 30, 2009 4:05 am

Hi,

As per the parjdev pdf, if NLS is enabled, the NLS Map tab will be available. I do not see this tab.

Are there any default NLS settings? Where can I obtain the information about this?

I have checked in Admin and the NLS settings are disabled for viewing for developers.

bakul · Post by **bakul** » Thu Jul 30, 2009 10:53 pm

Hi,

We have checked the NLS settings for source and target database and these are the same.
Therefore, the issue seems to be with DS NLS settings itself.

We have asked the Admin to provide details of the NLS setup as these are not accesible to us.

Will post them as and when we get updates.

ArndW · Post by **ArndW** » Fri Jul 31, 2009 1:59 am

ArndW wrote:Do you have NLS settings in your $DSHOME/uvconfig file? If not, then NLS is not enabled.

you should have read access to this file.

bakul · Post by **bakul** » Fri Jul 31, 2009 3:10 am

I did check the file.
THere is only one variable (NMEMOFF) related to NLS in the file. I am not sure if this indicates that NLS is enabled.

ArndW · Post by **ArndW** » Fri Jul 31, 2009 4:58 am

That parameter doesn't have to do with NLS; if your uvconfig has no NLS entries then any character conversion is not being done by DataStage. Read your Oracle and write to a text file, then look at the value in the text file (not with View Data in DataStage) to see if has been altered. What is your NLS_LANG environment setting?