NLS setting question ?

kaps · Post by **kaps** » Fri Sep 30, 2011 9:10 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 30, 2011 3:57 pm

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.