Regarding UTF8 NLS Mapping

[Vijay Kumar]

Hi,
We have enabled NLS on our Datastage server.
The project level default Mapping is UTF8 and Locale settings are US.ENGLISH.
The Oracle DB instance is created with the NLS parameters set to UTF8 both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are UTF8.

We are loading the UTF8 data to the oracle table using ODBC. When we read the data from the same table using ODBC the data is different. we are not able to point out where exactly we are going wrong.

Some times when we view the data from ODBC stage view option we get nls_mapping error.

Are there any other settings that we need to check on UNIX server or Oracle server?
Any pointers in this regard will be helpful.


Thanks in advance,
Vijay

[ray.wurlod]

What is the value set for NLS_LANG environment variable?

[Vijay Kumar]

Hi Ray,
Initially the NLS_LANG variables was not set.
Now I have set the NLS_LANG as en_US.utf8.
The following are my locale settings on UNIX box.
LANG=
LC_CTYPE="C"
LC_COLLATE="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_MESSAGES="C"
LC_ALL=
But still I am facing the same problem. I am not able to read the same data that I write to the database after setting the NLS_LANG variable.

Thanks & regards
Vijay

[Vijay Kumar]

Hi,
I have resolved the issue. We need to set EnableNcharSupport=1 in the .odbc.ini file for the ODBC connection String.

Thanks & Regards
Vijay Kumar