Character set issue

ray.wurlod · Post by **ray.wurlod** » Wed Jun 29, 2011 4:14 am

What was the NLS setting in the previous project? How did you move the hashed files? Is there a non-default NLS setting in the job?

DJRH · Post by **DJRH** » Wed Jun 29, 2011 4:57 am

Hi Ray,

In version 7.1 Windows OS the NLS is not there.
we copied the hashed files from 7.1 to 8.5 through winSCP in binary mode and processed it using fnuxi command
and the default nls setting is ISO 8859-1 for the job

Thank u

ray.wurlod · Post by **ray.wurlod** » Wed Jun 29, 2011 5:38 pm

Try setting the NLS map (in the job or in the stage if you prefer) to NONE.

DJRH · Post by **DJRH** » Wed Jun 29, 2011 10:24 pm

Hi Ray,

We tried executing by setting job NLS to NONE, still the issue exists.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 30, 2011 2:42 am

Hmm. Have you tried setting the map to ISO8859-1 explicitly in the job or stage?

ray.wurlod · Post by **ray.wurlod** » Thu Jun 30, 2011 2:45 am

One we should have asked at the top.

Is the character being passed through accurately and only being misreported in View Data? That is, is the character correct in the target which viewed with something other than DataStage data browser (which is notoriously bad at "un-American" characters in version 8)?

chulett · Post by **chulett** » Tue Jul 05, 2011 11:26 pm

You do realize that you've just repeated information you've already posted and didn't address at all the question that Ray asked you, yes?