Page 1 of 1
NLS setting for Oracle with AL32UTF8
Posted: Thu Jan 05, 2006 7:17 am
by victorbos
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
Posted: Thu Jan 05, 2006 8:01 am
by chulett
Search is your friend!
This post seems to have the information that you need. There were others, btw.
Posted: Tue Jan 10, 2006 7:44 am
by chulett
You really meant DUTCH_THE_NETHERLANDS.AL32UTF8 (no space) yes? Do you have NLS installed?
Posted: Wed Jan 11, 2006 1:44 am
by victorbos
Yes, I meant
DUTCH_THE NETHERLANDS.AL32UTF8
(what space?)
And yes: NLS is installed.
Victor
Posted: Wed Jan 11, 2006 8:26 am
by chulett
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.
Posted: Thu Jan 12, 2006 2:56 am
by victorbos
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
Posted: Thu Jan 12, 2006 3:06 am
by Vijay Kumar
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
Posted: Mon May 15, 2006 12:17 am
by victorbos
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