Regarding UTF8 NLS Mapping
Posted: Mon Dec 12, 2005 9:26 am
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
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