NLS problem?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 21, 2009 1:20 pm

The View Data tool is "one size fits all" and rarely fits perfectly. Ignore its little idiosyncracies - it's only about getting "a bit of a look" at the data.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Apr 21, 2009 5:23 pm

Also - make sure all your environment variables are set correctly for NLS, especially NLS_LANG (which I believe is used by Oracle).

Some examples from our system:

Code: Select all

LC_MONETARY=en_US.UTF-8
LC_NUMERIC=en_US.UTF-8
LC_ALL=en_US.UTF-8
LC_MESSAGES=en_US.UTF-8
LC_COLLATE=en_US.UTF-8
LC_CTYPE=en_US.UTF-8
LC_TIME=en_US.UTF-8
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252

The "?" usually means that it can't find a way to map that particular character in the character set you've selected.

Anthony1200 · Post by **Anthony1200** » Thu Apr 23, 2009 2:32 am

Hi,

Thanks for the help

I think where on the right track here, we added these settings to dsenv but still no success (the same char set as the database)
so I guess we will have to fiddle with this some more

Ill keep you guys posted, thanks for the help!

Anthony1200 · Post by **Anthony1200** » Fri May 01, 2009 3:10 am

Well, it seems it was just a NLS setting problem, it works fine now

Thanks for the help you guys!

sjfearnside · Post by **sjfearnside** » Fri May 01, 2009 6:30 am

Please post a detailed explanation of the solution for the benefit of others.

Thanks