NLS setting for Oracle with AL32UTF8

victorbos · Post by **victorbos** » Thu Jan 05, 2006 7:17 am

Hi all,

Does somebody know what NLS setting to use in datastage server to access data in an Oracle database in AL32UTF8?

thanks in advance,

Victor

chulett · Post by **chulett** » Thu Jan 05, 2006 8:01 am

Search is your friend! This post seems to have the information that you need. There were others, btw.

chulett · Post by **chulett** » Tue Jan 10, 2006 7:44 am

You really meant DUTCH_THE_NETHERLANDS.AL32UTF8 (no space) yes? Do you have NLS installed?

victorbos · Post by **victorbos** » Wed Jan 11, 2006 1:44 am

Yes, I meant
DUTCH_THE NETHERLANDS.AL32UTF8
(what space?)
And yes: NLS is installed.

Victor

chulett · Post by **chulett** » Wed Jan 11, 2006 8:26 am

Between "THE" and "NETHERLANDS".

I really think you need to have an underscore there. Other than that, I'll have to defer to one of the NLS experts on the forum here.

victorbos · Post by **victorbos** » Thu Jan 12, 2006 2:56 am

Ah, that space...didn't notice that

I actually copypasted the setting from

Code: Select all

SELECT USERENV ('LANGUAGE') FROM DUAL;

...which does return the string with that space....

Victor

Vijay Kumar · Post by **Vijay Kumar** » Thu Jan 12, 2006 3:06 am

Hi Victor,
set the NLS Mapping as UTF8 and also let me know how you are getting connected to Oracle. Are you using ODBC stage?
If Yes then set the EnableNcharSupport=1.
If you are using any other connection method then check the support for the NLS for those stages.

Also check whether the input file is really in UTF8 format or any other special characters which are not part of UTF8, those may not be get processed.

Hope this information may resolve your issue

Thanks & Regards
Vijay Kumar

victorbos · Post by **victorbos** » Mon May 15, 2006 12:17 am

Hi all,

Forgot to say that I did solve this with one extra line in dsenv:

Code: Select all

NLS_LANG=.AL32UTF8; export NLS_LANG

Victor