NLS_LANG value
Posted: Tue Mar 04, 2008 1:37 pm
Hello,
After reading 3 pages of posts related to the NLS_LANG variable, I'm still unsure about how to choose a proper value for this variable.
Many posts suggest to use the value used by the Oracle database accessed.
But some posts + other sources says that it is not necessarily the value to use.
On top of that, what would you do if you had to access, in the same job, 3 databases with 3 different NLS settings ?
Some articles says the NLS _LANG should reflect the client charset so that Oracle can perform the proper translation.
I'm assuming that the client in our case would be the datastage project, which means that the NLS_LANG variable should be set to match the NLS setting of the datastage project.
The question is now "how do I choose my project NLS setting ?".
According to the NLS guide, the value is chosen based on the character set of the tables you want to read /write to.
So this brings us back to the first solution which is to set the NLS_LANG to a value matching the database one...
Does somebody have an explanation ?
Thank you
After reading 3 pages of posts related to the NLS_LANG variable, I'm still unsure about how to choose a proper value for this variable.
Many posts suggest to use the value used by the Oracle database accessed.
But some posts + other sources says that it is not necessarily the value to use.
On top of that, what would you do if you had to access, in the same job, 3 databases with 3 different NLS settings ?
Some articles says the NLS _LANG should reflect the client charset so that Oracle can perform the proper translation.
I'm assuming that the client in our case would be the datastage project, which means that the NLS_LANG variable should be set to match the NLS setting of the datastage project.
The question is now "how do I choose my project NLS setting ?".
According to the NLS guide, the value is chosen based on the character set of the tables you want to read /write to.
So this brings us back to the first solution which is to set the NLS_LANG to a value matching the database one...
Does somebody have an explanation ?
Thank you