Page 1 of 1

NLS setting question ?

Posted: Fri Sep 30, 2011 9:10 am
by kaps
We have installed NLS in the server to resolve a SQL server datatype of varchar2 which was warranting for NLS installation.

After installation, server level NLS was set to MS-1252CS by default and server and parallel maps for projects were set to ISO8859-1.

This was causing problems where we used CFF stage to read EBCDIC values so we have changed the server and parallel maps to UTF-8 which resolved that particular issue but we would like to make sure that this does not affect anything else.

Correction : UTF-8 did not resolve the issue. We still have the issue.

Please advise.

Posted: Fri Sep 30, 2011 3:57 pm
by ray.wurlod
Please describe your symptoms more completely. "Causing problems" isn't that helpful - I have children who do that!

Any ...CS map is only related to communication between DataStage server and client. EBCDIC conversion should not be an issue, because every EBCDIC code point has an ASCII equivalent.