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
NLS setting for Oracle with AL32UTF8
Moderators: chulett, rschirm, roy
Ah, that space...didn't notice that
I actually copypasted the setting from
...which does return the string with that space....
Victor
I actually copypasted the setting from
Code: Select all
SELECT USERENV ('LANGUAGE') FROM DUAL;
Victor
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
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
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
Hi all,
Forgot to say that I did solve this with one extra line in dsenv:
Victor
Forgot to say that I did solve this with one extra line in dsenv:
Code: Select all
NLS_LANG=.AL32UTF8; export NLS_LANG